Audits Overdue

Query : Audit/Visit Scores Latest/Completed

Selected Column : Code

Aggregate Function : Count

Using the following filters, the KPI metric provides a count of sites where the next audits are overdue based one the due date being in the past.

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

Query : Audit/Visit Scores Latest/Completed

Selected Column : Site Code

Aggregate Function : Distinct

Using the following filters, the KPI metric provides a distinct count of sites where the next audits are overdue based on the due date being in the past.

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