Measure pickup time

Questions & Answers
2

When you want to compare two events on dates (created date and first status change), you would like to use Issue level calculations with MDX formulas.

Here is an example formula for it:

Avg(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
-- filter by issue properties, in this case Issue creation date
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
  ),
  CASE WHEN 
-- filter with measure to pick issues based on dimension usage in the report and validation if issue has a transition to status In Progress
    ([Measures].[Transitions to status],
     [Transition Status].[In Progress],
     [Time].CurrentHierarchy.DefaultMember) > 0
  THEN
 -- calculated time in days between Issue created date and first transition to status In Progress:
   DateDiffDays(
     [Measures].[Issue created date],
    ([Measures].[Transition to status first date],
     [Transition Status].[In Progress],
     [Time].CurrentHierarchy.DefaultMember)
   )
   END
)

Daina / support@eazybi.com

1 Like