Hi,
i have a report that takes a lot of time to load, its a project with 107230 tickets, but with filters, and there oare ther reports, so they do load mostly - this is the table
and this is one of the calculations that i think takes time to load :Cache(
CASE WHEN
– Only calculate for individual issues to reduce complexity
[Issue].CurrentHierarchyMember.Level.Name = ‘Issue’
THEN
– Cache the total days calculation to avoid recalculating it
CASE WHEN
Cache(
Sum(
[Transition Status].[Transition Status].Members,
[Measures].[Days in transition status]
)
) > 0
THEN
– Calculate percentage for current transition status
[Measures].[Days in transition status] /
Cache(
Sum(
[Transition Status].[Transition Status].Members,
[Measures].[Days in transition status]
)
)
END
END
) Maybe you have a faster solution? The goal of this table is to show the tickets their percentage in each status transition, the time to resolution, sla also the average time in transition. Thank you in advance noa