Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

how is total age calculated in average age report

Every week I have a look at the average age report, use the same filter, timeframe and lookback window. I noticed the data of previous weeks changes, this seems incorrect, as those weeks have past, so the data of these weeks shouldn't change.

For instance this week the average age of last week is 118, but when I looked last Monday it was 105.

Even if items that were on the backlog last week the average of that week shouldn't change today, as the average of the issues last week shouldn't go further than last week.

Am I missing something here?

2 answers

1 accepted

2 votes
Answer accepted

Hi everyone, 

I was able to find some information on how it's calculated: 

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 an 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 does rely on the implementation. It's possible if there were some index inconsistencies that were solved by a later reindex, that this could explain the difference in numbers. 

If you want to dig deeper, the code can be found in,48,60,76,121. 

I hope this answer is helpful. 

- Jennifer

Thanks for your reply, this clarifies the calculation. :)

Like J van Leeuwen likes this
Jack Brickey Community Leader Mar 26, 2019

@J van Leeuwen , thanks for this info. I'm wondering if this is detailed in Atlassian documentation and if not I wonder if maybe turning this into an article in the Community would be a good idea?

Like J van Leeuwen likes this

Hi @Jack Brickey - You're very welcome. Absolutely, it would! That's next on my list. :) Glad it was helpful, @Sanne van Tongelen ! 


Here's the documentation you can reference in the future: How is the Jira average age report calculated :)

Jack Brickey Community Leader Mar 26, 2019

awesome! +++

0 votes
Jack Brickey Community Leader Sep 08, 2018

@Sanne van Tongelen, I have always found the chart to be difficult to consume but TBH i have not spent a lot of time recently trying to decode the math. I would be interested in your observations week-over-week. Specifically, do you see that week-over-week the the bar changes for several weeks back (not just last week). I don't know what you mean by "total age". My understanding is this chart is trying to illustrate if you are keeping up w/ you backlog or not. If the trend is climbing then you are falling behind if declining you are making positive progress and if level then you are treading water. I haven't monitored the number much.

Thanks for your response.

I understand that it is meant to see if you keep up with your backlog.
We weekly keep track of the average age to see how we are doing over time and motivating the Product owner to keep the average age at a certain level. However we found the data to be inconsistent, at least to what we expect. Maybe we are expecting the wrong thing.

I added the numbers in our external KPI dashboard and in week 35 and 36 I had the numbers: 117 and 118.
However if I have a look at the chart today it has changed to 122 and 121:

Capture.PNGIn my opinion that wouldn't be possible, as that is changing the past. Today's stories shouldn't change the average of past weeks as the average back then was the average on that point in time.

Hopefully this creates clearance on my issue. :)

Like Elías likes this
Senya I'm New Here Aug 19, 2022

Thank you. How do I get to the Data Table?

Suggest an answer

Log in or Sign up to answer