Hello,
Has anyone worked with PowerSchool attendance in Tableau, and if so, were you able to get an accurate ADA for each school day?
I am running into an issue with not being able to find the total enrollment per day.
Not a PowerSchool user but it looks like PowerSchool allows customers to set a specific code for this calculation depending on how the district / school wants the value calculated. There is a field "This attendance code is considered in ADA calculations." The directions indicate:
Select if this attendance code should be considered in Average Daily Attendance (ADA) calculations.When enabled, the attendance code is included in ADA calculations. This means the conversion will respect the Presence Status of the assigned code and/or any minutes accrued. For example, Meeting attendance records with a Presence Status of Absent will be treated as such by a Period-to-Day conversion and minutes assigned to a Time attendance record will be counted towards a Time-to-Day conversion.
When not enabled, the attendance code is excluded from ADA calculations. This means the conversion handles the attendance code as if no attendance was taken. For example, Meeting attendance records results as a present because the absence of an attendance record (blank) is the same as a default present. Whereas, Time attendance records result in no minutes granted as if attendance was not taken.
https://ps.powerschool-docs.com/pssis-admin/latest/attendance-codes
