Average Completion Formula

Questions & Answers
1

Hello,

I wanted to create a graph that shows me the average completion days (time an issue first goes to the ‘in progress’ status to time an issue first goes to ‘done’ status/ amount of issues that transitioned to done status in that time period).

2

Hi @Rachael_mdx,

When calculation completion time based on particular transitions, then you might want to use issue historical measures and dimensions. Full list of history measures you can see in the documentation: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history.

For the graph, create a new calculated measure to get average completion days using those historical measures. The calculation will go through each issue and check the time and date of Transition to status first date for transition status In Progress and Done. Then calculation will count days between those two transition timestamps.

NonZero(Avg(
  --filter all issues that were completed in a selected period
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    DateInPeriod(
      --date of first transition to status Done
      ([Measures].[Transition to status first date],
      [Transition Status].[Done],
      [Time].CurrentHierarchy.DefaultMember),
      --selected period on rows or pages
      [Time].CurrentHierarchyMember )
    ),
  --for each issue count days between two transitions
  Datediffdays(
    --date and time of first transition to status In Progress
    ([Measures].[Transition to status first date],
    [Transition Status].[In Progress],
    [Time].CurrentHierarchy.DefaultMember),
    --date and time of first transition to status Done
    ([Measures].[Transition to status first date],
    [Transition Status].[Done],
    [Time].CurrentHierarchy.DefaultMember)
  )
))

More details on calculated measures you will find in the documentation: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members

Check out community post on similar use cases:

Best,
Zane / support@eazyBI.com