How can you measure how much a feature spend in each state in azure devops?

user_4525685 0
Viewed 1099

I want to the cycle time of my features for each state they spend on. I am using the cycle time widget but this doesn't show the time for each state and it doesn't go beyond 180 days.

azure-devops
1 Answers

You may try to create a report in PowerBi, which can calculate time-in-state. The time that a work item spent in a specific state can now be calculated by summing the Date Diff in Days for each work item. This calculation will include all of the time spent in a specific state even if it has switched between states multiple times.

State Time in Days = 
CALCULATE (
    SUM ( 'View Name'[Date Diff in Days] ),
    ALLEXCEPT ( 'View Name', 'View Name'[Work Item Id] ),
    'View Name'[Date] <= EARLIER ( 'View Name'[Date] ),
    'View Name'[State] = EARLIER ( 'View Name'[State] )
) + 0

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/create-timeinstate-report?view=azure-devops#add-is-last-day-in-state

user_54258250
Related