Thought is would be eazy... but still can't do this type of AGGREGATION

Using “Days in transition status until now” which uses the “Issue status” property which is great since it does things broken down by individual status’… however, since I have the “ISSUE” dim on my ROWS I get every single issue in a very long table… I added the TOTAL across each row col but there is no way to choose “TOP x” … Really struggling with something I thought would be a simple Aggregation
Looking for a custom calc field that does what Days in transition status until now does but ADDS UP the individual status’ instead of a number for each one so I can do a TOP 10 on the new total column

here is Days in transition status until now:
– days in transition status when issue was in this status in previous times
IIF(
– if report uses Status dimension instead of Transition status it should work as well:
[Status].CurrentHierarchyMember.Level.Name = “Status” and Not [Transition Status].CurrentHierarchyMember.Level.name = “Transition Status”,
([Measures].[Days in transition status],
[Transition Status].[Transition status].GetMemberByKey(
[Status].CurrentHierarchyMember.Key
)),
[Measures].[Days in transition status])
+
– days since last transition to this status
NonZero(SUM(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
– for unresovled issues only
IsEmpty([Issue].CurrentHierarchyMember.Get(“Resolved at”))
AND
IIF([Transition status].CurrentHierarchyMember.Level.Name = “Transition Status”,
[Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
AND
IIF([Status].CurrentHierarchyMember.Level.Name = “Status”,
[Status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
),
CASE WHEN
[Measures].[Issues history] > 0
THEN
DateDiffDays(
[Measures].[Issue status updated date],
Now()
)
END
))
and here is the Issue Status property:
[Status].[Status].getMemberNameByKey(
[Issue].CurrentHierarchyMember.get(‘Status ID’)
)

@erichard00

To see the total column (and also Transtion statuses).
First, remove the Transition Status dimension from the columns.

Now, go to the column “Days in transition status till now” and choose “Drill into” → "Transition Status → All transition statuses. See the picture below:

And now it’s ok to select the Top 10 rows on All Transition Statuses.

Kind regards,
Ilze support@eazybi.com