Hello,
I want to calculate the time issues were in a specific status. In my case it is the status “In Progress”. I added a calculated member:
Sum(
Filter(
Descendants(
[Issue].CurrentHierarchyMember,
[Issue].[Issue]
),
(
[Measures].[Transitions from status],
[Transition Status].[In Progress]
) > 0
AND
DateInPeriod(
(
[Measures].[Transition from status first date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember
),
[Time].CurrentHierarchyMember
)
),
(
[Measures].[Workdays in transition status],
[Transition Status].[In Progress]
)
)
It seems to work correctly but it is too slow. When I open the report it runs out of time. Is there a way to calculate this time more efficient?