Count of Latest Completed Assessment

Query : Assessment Scores Latest/Completed

Selected Column : Site Code

Aggregate Function : Count

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

Column	Operator	Type	Value	Unit	Logic
Assessment Status	Equals	Fixed	Complete	-	and
Assessment Template	Equals	Fixed	“Assessment Template”	-	and
Assessment Scoring	Equals	Fixed	“Score”	-	and

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

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