How to get the number of days spent in an status with a calculated measure?

Hi @rdelabarrera ,

​The usual way of getting the time an issue spent in a particular status is to use the dimension Transition status and the measure [Measures].[Days in transition status].

You might find the instructions for the basic report here - How much total time spent in each status.

​You might as well want to see the time spent in a particular status even while the issue is still in that status.
​You might want to explore another community post addressing that matter here - How to calculate Days in transition status including the time in current status.

However, if the above threads did not help and you cannot find the answer in the eazyBI community portal - please feel free to write your inquiry to the eazyBI support e-mail: support@eazyBI.com.

​Kind regards,
​Oskars / eazyBI support

1 Like