Average Completion Formula

Questions & Answers
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