Need help with some dashboard queries.

Copper Contributor

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!

1 Reply
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.