Days in transition status for CurrentHierarchy member

Hi!
How I can get dialy value for [Measures].[Days in transition status]?
My issue was 90 days in transition status “In progress”. that means if i get one day from this period, it will be 24 hours in progress for this day
how can i deal with it?

Hi @kvadrokopter

You may want to create a new calculated measure where you get minutes in transition status, and then set the formatting #hh #mm for the measure.
The formula for this measure would be the following:

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

You can read here how to define new measure: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember

Ilze , support@eazybi.com

1 Like