How can I generate "Metric" type reports for counts of data quality type issues?

[trevor.lowing]

How can I generate "Metric" type reports where I look for counts of data quality type issues?  I have several report dashboards that teams can use to identify the missing information but I'm looking for something to tally up the missing data items by container and generate a quick summary report. 

 

User Story

No Owner and ScheduleState= Completed, Defined, In-Progress
No Description and ScheduleState= Completed, Defined, In-Progress
No AcceptanceCriteria and ScheduleState= Completed, Defined, In-Progress
No Type and ScheduleState= Completed, Defined, In-Progress
No Release and ScheduleState= Completed, Defined, In-Progress
No PlanEstimate and ScheduleState= Completed, Defined, In-Progress
No Feature and ScheduleState= Accepted, Completed, Defined, In-Progress
Task
No TaskActualTotal and and ScheduleState= Completed, In-Progress
No Owner and ScheduleState=accepted, Completed, Defined, In-Progress
No Estimate and Todo >0 ScheduleState=Defined, In-Progress
Not Complete and Todo =0 State=accepted, Completed, Defined, In-Progress
Actuals=0 and State=Completed
Portfolio Item Project Epic
No Parent
Portfolio Item Feature
No Parent

[Pat Cousins]

Hi Trevor, this may be close to what you're looking for: the Query Counter app - App of the Week - Query Counter .  You can use the same queries you use in your dashboards, and this will simply display the count of items that match the query.  I have a dashboard, with three column layout, that has all the queries I use for data governance checks.

[trevor.lowing]

Here's a good example that's close to what I'm looking for:

 

https://stackoverflow.com/questions/22428560/using-collection-summaries-for-multi-select-fields