A modern Azure DevOps dashboard widget that takes the Query of your choice and rolls up the results into a per-State count — plus a Total card. Built by Deenu Gengiti.
What it does
You already shape the data with WIQL — this widget simply makes the result count visible on a dashboard.
- You pick any Shared or My Queries entry when configuring the widget.
- The widget runs the query through the Azure DevOps REST API.
- Results are grouped by
System.State; one metric card is shown per state plus a Total. - Click the tile to open the underlying query in a new tab.
The query is the single source of truth. Any filter — work item type (including custom WITs like PMO Epic), area path, iteration, tags, custom fields, parent / child relationships — is expressed once in the query.
Highlights
- Modern Fluent UI aligned to the Azure DevOps palette (Azure blue → cyan accent gradient, full dark-mode auto-adapt).
- Tree / one-hop queries are supported (distinct target work items are counted).
- Custom processes and custom WITs out of the box.
- Zero telemetry and
vso.workscope only — read access to work items and queries, nothing more. - Inline SVG iconography — crisp on every DPI and theme.
Quick start
- Create or open a Shared or My Queries entry in Boards → Queries.
- Edit your dashboard and add the ADO Query Roll-Up widget.
- Give it a title, pick a tile size, and choose your Query from the dropdown. Save.
- The widget appears on the dashboard with live counts and refreshes on dashboard load.
Supported environments
- Azure DevOps Services (Cloud)
- Azure DevOps Server / TFS 2017 (15.0) and later
Permissions
vso.work — read access to work items and queries. Nothing else.
Author & license
Built and maintained by Deenu Gengiti. Released under the MIT License.