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’)
)