We are trying to build a query that will search students by how many times they are absent in a period. They want to be able to change the total amount for each period.
Has anyone built a query that they could share that will do that??/
The Attendance Query Bank is a resource of various attendance queries. Query banks are the first FAQ in each category in Freshdesk.
Period ATT: List of Absence Entries for a 1st Period Class on a Specific Date
List of student Absence Codes for a 1st period section with Attendance Date on a Specific Date
This query was adjusted from the list of queries and is run for 1st period after a specific date - you can add/modify to reflect the periods you are searching for.
LIST STU SEC MST ATT STU.ID STU.NM SEC.SE ATT.DT ATT.A1 IF ATT.DT > ##/##/20##
If you need further assistance, please submit a support ticket through Freshdesk.