create a gadget amount of time in a state

Questions & Answers
1

Hi! I’m new to Eazybi. I need to create a gadget that reports bugs and the number of days they’re in a specific status in a table. I used the following formula in the rows “Issue, Assigned, Page, Project, IssueType,” and in Measure: “Days in transition status until now.”

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

I would appreciate it if you could help me if you find any errors in the formula or give me a new one. Thanks!

2

Hi @emiliano.sant,

This expression requires the individual status to be defined to see the time in that specific status.
I suggest using the dimension “Transition Status” in report columns or pages to specify the status for the calculation.

Regards,
Oskars / support@eazyBI.com