Can anyone point to simple queries or reports to generate per-student absenteeism rates? I know this is possible but the existing reports and table structures make it difficult to find and calculate.
1 row per student with
total absences in year,
total attended present days,
total enrolled days,
(ideal; easy to calculate) percentage of total present days divided by total enrolled days.
I feel like I've found this before but with extensive searching and reading I can't find what I need at the moment.
I run this query to get the attendance present/ enrolled. I haven't tried combining with tardies.
LIST STU AHS ATT STU.SC STU.ID STU.LN STU.FN AHS.SCL AHS.EN AHS.AB AHS.PR (( AHS.PR/CAST(AHS.EN AS DEC(10,3) )*100 )) BY STU.SC IF AHS.EN # 0 AND AHS.YR = "2018-2019"
The query worked great once I removed the ATT