Need help in creating measure to find duration of an issue in a each status

Hi Experts,

Need your help eazyBI is new for me, I need to find that how much time issue spend in each status and how many times issues moved to a particular status.

Kindly suggest, I have used the pre-build measure but not getting correct information.

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

Hi @VY_NY

Why do you think that the predefined measure is wrong? What is the report you are using this measure in?

To count the times issue moved to a particular status you can try using the measure “Transitions to status” with dimension “Transition Status” as page filter.
This measure counts the times issue goes to a particular status(-es) from Transition Status dimension.

Martins / eazyBI team

1 Like