It's not too late to register for AeriesCon Spring 2019! Book your seat now!
Start a new topic

Chronic absenteeism and per-student attendance totals?

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.  


Desired output:  

1 row per student with 

total absences in year, 

total attended present days, 

total tardies, 

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.


Thanks!


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"


1 person likes this

The query worked great once  I removed the ATT


thanks

Login to post a comment