I need to make a report that calculates the average time until the Issues are in a series of status without taking into account the time they spend in a different series of other status
Can you tell me how I can get this?
Thank you in advance.
In this case, you could create a new calculated member in “Transition Status” dimension to aggregate transition statuses needed for your calculation.
Next, you could enable and select your new calculated member in the report.
After that, you could create a new calculated measure:
[Measures].[Days in transition status] / [Measures].[Transitions from status issues count]
That would calculate the average time (in days) for the transition statuses from the “Transition Status” dimension calculated member.
Martins / eazyBI support