How is the Jira average age report calculated?

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

The Average Age report shows the average age of unresolved issues for a project or filter. This article explains in more detail the calculation used to generate the report. 

Solution

The Average Age Gadget displays a bar chart showing the average number of days that issues have been unresolved. For every issue, we:

  • extract the creation date and resolution date
  • iterate over a list of contiguous time buckets (configurable by hour, day, month or year)

IF

  • the issue creation date is before the start of the period and the resolution date is after the start of the period

We then compute the amount of time the issue has been opened up to the end of this period using min(resolutionDate, periodEndDate) – issueCreationDate and increment a count of open issues for that period.

The result is a map of periods to total time that the issues have been opened. We compute the average by dividing the total time by the total number of issues recorded per period. 

This gadget relies on the org.apache.lucene.search.Collector implementation. 


Description

The Average Age report shows the average age of unresolved issues for a project or filter. This article explains in more detail the calculation used to generate the report. 

ProductJira Core, Jira Software, Jira Service Management
Last modified on Nov 23, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.