RP performance
Given Schools = schools actively assigned to that RP (from rp_school_assignments), regardless of whether they've ever been visited. Unique Schools Visited only counts visits to schools currently assigned to that RP — a visit to a school no longer on their assignment list doesn't count here, so Coverage % never exceeds 100%. Coverage % = unique schools visited (within the selected date range) ÷ given schools. Avg Time Spent and Check In Check Out Discipline are always calculated from 1 Aug 2026 onward (even if an earlier Check-in From is selected), since tracking only became reliable from that date — every other column still uses the exact selected date range. Avg Time Spent only counts visits with a recorded check-out. Check In Check Out Discipline = % of visits (with both check-in and check-out GPS) where check-out happened within 1 km of check-in. Class Observations = FCP + Awakening + Nav Jagran + ACP + AACT (verified to always sum exactly). Avg Score is out of 15 for FCP/ACP and 21 for Awakening/Nav Jagran (AACT has no score). Sorted highest coverage first.