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.work scope 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.
