Forum Discussion
Need help with some dashboard queries.
I am working on a dashboard and I have some outstanding things that I don't know how to do. Any advice is appreciated.
1. I want to show how many work items were made active in a certain period of time, ex: 1/1/2023-1/14/2023. These items may be in any state currently. NOTE: We are not utilizing sprints for this particular work so I am hoping to be able to write a query.
2. How an I show a simple number trend of month over month work items closed? I can write the query to find the number but any ideas on how to make it a chart with monthly totals?
3. Is there a way to show how many days a work item has had a certain tag on it? In my particular case, the tag is BLOCKED and I want to know how long the tag has been there. NOTE: I would assume that the natural answer here is to utilize the state instead of tagging the story, but that is not our current workflow.
Thank you in advance!
- Hi,
Use the Time in State for Azure DevOps extension to calculate a Work Item's length in a particular state https://marketplace.visualstudio.com/items?itemName=SaaSJet.tis-azure .
You can also use reports such as State Count and Transition Count.
It is also possible to view this information visually by generating charts for each report, a chart for one Work Item.
Try it; I hope it will be helpful to you.
