Dashboard widget for Azure DevOps that displays the result of an
Analytics OData $count (or aggregate) query as a single large
number with color thresholds (green / amber / red).
Use cases
Count of open PBIs whose every child Task is Done
Count of bugs created this sprint
Any other Analytics OData query that returns a scalar number
Configuration
Field
Description
Title
Title shown above the number
OData URL
Full URL to an Analytics OData query that returns a scalar (/$count) or an aggregate
Amber threshold
Number ≥ this turns amber
Red threshold
Number ≥ this turns red
Example OData URL
https://analytics.dev.azure.com/{org}/{project}/_odata/v3.0-preview/WorkItems/$count?$filter=WorkItemType eq 'Product Backlog Item' and State eq 'Active'
The widget calls the URL with the user's Azure DevOps token, so all
project security trims apply automatically.
