Forum Discussion
JVickey
Sep 15, 2023Copper Contributor
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 ...
Iryna_Komarnitska
Sep 22, 2023Copper Contributor
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.
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.