Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How caclculate TouchTime for Azure DevOps

Hello   i want to calc Touch Time (sum working time by closed items per period in certain State). In my data set i have: Work Item Id - item State Time in Days - time in certain State State - St...
Need Help
Iryna_K's avatar
Iryna_K
Frequent Visitor
2 years ago

Install the Time in State for Azure DevOps extension and follow this guide to calculate Touch Time. Also, you can download these reports to Excel and further manipulate the data there.

  1. Select a query for the report generation

  2. Select a calendar for the right calculation

  3. Filter Work Items by Closed

  4. (Optionally) Select an items range in the “Work Item“ dropdown (to display items that were closed in such period)

  5. Select a period in the “Time range” dropdown (to display the time calculation for the selected item range in the specific time range)

  6. Look at the State column and the time that item was in such state.

 

I hope it will be helpful for you!