Hi
I would like to create a Report that is showing the time an item spent/spents in a status. The item might be still in the current status. The item might be multiple times in the status
Currently I am trying to figure out how to get it work. I added Transition Status & Measures as columns. Selected the relevant Transition Status “Review” and “Analyzing”. Is there any way to get the total days spent in a status:
- can be the current status (Days in transition won’t work then, right?)
- the item could have entered the status multiple times → sum up the days of each time it was in the status, if it is its current status then add the days from when it transitioned into the status till today
- when it skipped the status/never entered the status → it should display 0
I would like to something like this:
1st row: transitioned 5 days ago to the “Review” status
2nd row: transitioned yesterday to the “Review” status
3rd row: wasn’t in the “Review” status but transitioned 12 hours/half a day ago to the “Analyzing” status.
Test is the column that shows the days in that status.
I found this thread How much total time spent in each status but Days in Transition doesn’t work, as the Item might still be in the status.
Thanks a lot in advance and best regards