Forum Discussion
Az_Pre4me
May 18, 2021Copper Contributor
Export data to excel from State graph in devops
Apologies I am new in a company and using Azure devOps for the first time... We follow a sprint lifecycle in for each user story as it passes from developments to test to production. I would lik...
otonieljn18
Oct 04, 2023Copper Contributor
Az_Pre4me Has anyone found the way to do this?
Iryna_Komarnitska
Oct 09, 2023Copper Contributor
Hi everyone
I can offer another solution without exporting to Excel.
A Time in State for Azure DevOps extension calculates how long a Work Item is in a particular state. The reports are generated automatically; you can choose any period, set up calendars, etc. There are also charts that visualize the data obtained in the report. Here is a link to it:https://marketplace.visualstudio.com/items?itemName=SaaSJet.tis-azure
I can offer another solution without exporting to Excel.
A Time in State for Azure DevOps extension calculates how long a Work Item is in a particular state. The reports are generated automatically; you can choose any period, set up calendars, etc. There are also charts that visualize the data obtained in the report. Here is a link to it:https://marketplace.visualstudio.com/items?itemName=SaaSJet.tis-azure