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?
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 , email@example.com