Sample Widget Daily Absent Count

The Attendance List public query used for the widget is:

K12.Student R0, K12.EnrollmentInfo.StudentSchoolYear R1, K12.EnrollmentInfo.StudentEnrollment R2, K12.AttendanceInfo.StudentDailyAttendance R3, K12.AttendanceInfo.Setup.SchoolAttendanceReasons R4 (CodeAbsReasSchYearGU,R3.CodeAbsReas1GU,Outer), K12.AttendanceInfo.Setup.DistrictAttendanceReasons R5 (CodeAbsReasGU,R4.CodeAbsReasGU,Outer)
COLS R0.FormattedName, R0.Age, R0.BirthDate, R3.AbsDate, R5.Abbreviation, R5.Description, R5.Type (,,,,,,,Code), R1.Grade (,,,,,,,Description)
If R5.Type In ('EXC', 'UNV', 'UNE') And R3.AbsDate <'$DATE' And R3.AbsDate >='$DATE-30'

Sample Widget - Daily Absent Count

This is a Query widget that shows the absences by day for all grades at a given school.

Daily Absence Count Query

The Rules set for the colors of the bar graph are: