Report for the amount of time in a status

Questions & Answers
2

Hi @agupta,
For the time from one status to another use this formula, in my case I am checking time from In Progress to Done - Avg from In progress to Done:

  Avg(
    Filter(
      Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    -- filter with measure to pick issues based on dimension usage in the report and validation if issue has a transition from status In progress
     ([Measures].[Transitions from status],
     [Transition Status].[In Progress])>0
    AND
    -- filter by issue transition date from status In progress
    DateInPeriod(
      ([Measures].[Transition from status first date],
       [Transition Status].[In Progress],
       [Time].CurrentHierarchy.DefaultMember),
      [Time].CurrentHierarchyMember
      )
    ),
    -- calculated time in days between first transition date to status In progress and first transition to status Done:
    DateDiffDays(
      ([Measures].[Transition to status first date],
       [Transition Status].[In Progress],
       [Time].CurrentHierarchy.DefaultMember),
      ([Measures].[Transition to status first date],
       [Transition Status].[Done],
       [Time].CurrentHierarchy.DefaultMember)
    )
  )

Also, you can check my colleagues answers to similar questions here:

…and here:

best,
Gerda // support@eazyBI.com