Measure pickup time

Questions & Answers
1

I am looking for a way to visualize the average time it takes until a ticket is picked up.
Our workflow in Jira is status: Backlog -> ToDo -> In Progress.
I want to see the average time until a ticket is set to In Progress.
Since I am total EazyBI noob I am seeking out help from you wizards.

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