Sample Widget - Attendance by Grade

This is a Query widget that shows the year-to-date absences by grade level.

Attendance List Public Query

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'

Birth Month distribution

The query can be copied and pasted into the Type in Query tab of the Query view to create this public query.