How is the Jira average age report calculated?
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
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.
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)
- 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