Discipline Distribution Report – Prevent Duplicate Counts for Concurrently Enrolled Students
The report currently counts a student’s ADS record multiple times if they have more than one STU record due to concurrent enrollment. Joining ADS to STU only on ID inflates totals. Adding STU.SC = ADS.SCL resolves the issue by ensuring each incident is counted only once per school.
3
votes
