This is how to query students' Attendance percentages for a date range using Attendance History.


Step 1: From Attendance History Config, choose the date range 

  • Choose the From/To dates for the desired Attendance date range


Step 2: Select Update All Schools Now 

  • An email will be sent when this process is completed


Step 3: Run the following query

  • LIST STU AHS STU.SC STU.ID STU.NM AHS.SP AHS.EN AHS.AB AHS.PR (( LEFT ( (( 100 * AHS.PR / AHS.EN )) , 5 ) + "%" )) BY AHS.SCL IF AHS.EN > 0 AND AHS.YR = "2023-2024" AND AHS.SCL = STU.SC



NOTE: The Attendance History Config will reset over night or the data can be reset manually by rerunning the Update Attendance History process with the From/To dates updated to the full year date range and selecting Update All School Now.