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?
Anyone have any good queries in Aeries or SQL for calculating truancy rates?