EazyBI Calculate transition time

[Michael Angelo Timoteo]

I have a transition with "Open => In Progress" that only happen in a minute. How do I calculate the total minute spent on that transition? 

In my history, Open is 2018-5-8 12:40:00 AM and the In Progress is 2018-5-8 12:50:00 AM so in pure calculation that is suppose to be 10m. 

I have been reading posts and I cannot find any that might be useful in doing this, can you help me produce this in the EazyBi Report?

[Ilze Leite-Apine - eazyBI]

Hi, 

in eazyBI, there is a standard measure "Days in transition status" that can be used with Transition dimension.

To get this metric displayed in minutes (not in days), create a new measure where you calculate minutes from days, and then select formatting ##d ##h ##m for the measure. The calculation would be the following:

[Measures].[Days in transition status]*24*60

Use the measure together with the transition you needed!

Ilze, support@eazybi.com