Assessments Overdue

Query : Assessment Scores Latest/Completed

Selected Column : Site Code

Aggregate Function : Count

Using the following filters, the KPI metric provides a full count of the assessments overdue based on the due date being in the past. If the Aggregate Function is updated to Distinct, you will have a count of sites with one or more overdue assessments.

Column	Operator	Type	Value	Unit	Logic
Due Date	Less Than	Relative	0	Day	and
Assessment Status	Is Not Equal To	Fixed	Complete	-	and