I thought I had found a way to do this, but in looking again I think the best I came up with was to run a series of reports (absence totals and enrollment totals) and then crunch the data together using spreadsheets or Report Tags, which is nowhere near as elegant as the Query you suggest. If anyone has a clean suggestion, I'd love it!
Hello! Did anyone figure out a query for truancy rate?
Does anyone have an update on queries to update truancy rates?
Leanne Hartley
Anyone have any good queries in Aeries or SQL for calculating truancy rates?