"Workdays in transition status" upgrade

[gon4]

Hello! We have a report that shows “Workdays in transition status”.
But issues are included in the statistics only after they have left the target status.
Is it possible to have statistic for issues that only come to target status?
Thanks for your help!

[Marilou]

Hi @gon4

I think you can find the query you are looking for on this thread:

How to calculate Days in transition status including the time in current status

The measure Days in transition status works for issues that already moved out from the status. Zeros might indicate an issue was moved out of the status shortly after adding to the status (or have transitioned to the same status). It does not include the time since the last status update. The following MDX formula (use it to define a new calculated member in Measures) will include in the calculation also days in the current status: -- days in transition status when issue was in this status in …

have a good day,
Marilou