Count of Latest Completed Audit

Query: Audit/Visit Scores Latest/Completed

Selected Column: Code

Aggregate Function: Count

Using the following filters, the KPI metric provides a count of the latest completed audits of the given type with the specified score across all sites.

Column	Operator	Type	Value	Unit	Logic
Status	Equals	Fixed	Completed	-	and
Audit Template	Equals	Fixed	“Audit Template”	-	and
Score	Equals	Fixed	“Score”	-	and

Using the following filters, the KPI metric provides a count of the latest completed audits of all types with the specified score for a given site.

Column	Operator	Type	Value	Unit	Logic
Status	Equals	Fixed	Completed	-	and
Site Name	Equals	Fixed	“Site Name”	-	and
Score	Equals	Fixed	“Score”	-	and