Lead time for issue types from status C to G

Questions & Answers
4

Hi @gerda.grantina - it looks like the below report measure query works, however 2 issues:

  1. im unable to get a average workdays view
  2. im unable to add time in Rows so i can see a trend over time

Any advice?

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