I’m trying to measure how much time on average my team spends working on an issue. Active work is reflected in In Progress status, that then moves to Awaiting Feedback. There are often several In Progress → Awaiting Feedback → In Progress loops and I’m not sure if
Average workdays in transition status measures what I need. Example:
1st iteration: 10 days
2nd iteration: 3 days
3rd iteration: 1 day
total days spend in In Progress status: 14
1st iteration: 5 days
2nd iteration: 2 days
3rd iteration: 3 days
total days spend in In Progress status: 10
The correct average I would like to see in the report: (14+10)/2=12
What I’m afraid eazyBI will calculate: (10+3+1+5+2+3)/6=4
Question: which one of the calculations is true for
Average workdays in transition status measure? And if the second one, how do I build a report that calculates the first one?
Thanks in advance!