This is how to Query students' Attendance percentages, including Independent Study Complete numbers 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.ISC AHS.PR (( LEFT ( (( 100 * ( AHS.PR + AHS.ISC) / AHS.EN )) , 5 ) + "%" )) BY AHS.SCL IF AHS.EN > 0 AND AHS.YR = "2024-2025" 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.