Average age chart not working


We made a deeper analysis of the average age chart because old historical values are constantly changing. You would expect to see a trend, in our case per month, but if previous months are changing all the time it is quite useless.

When investigating I can't even get the current month figures to be correct. Does anyone know the JQL behind the scenes?

For example our Average Age Chart now say that we in January 2018 have 305 unresolved issues. If I use the same filter and add the "AND resolution is Empty" I get 283 issues. Same if I try with "resolved is Empty" or "resolutiondate is empty". If I instead add the "AND resolved >= 2018-01-01" I get 32 issues, so if it would count all unresolved PLUS the ones resolved in January it still doesn't count to 305 but rather 315. So how the heck does it come to 305 unresolved in January???

It gets even more wrong if I try to sort out the previous months figures since I don't understand the mechanism behind. Can anyone help here?

1 answer

1 accepted

0 votes
Accepted answer

I think I figured out the answer myself by exporting everything to excel and trying to simulate the same result.

In fact, the average age chart does not count the issues created and solved within the same month. So the fast ones doesn't count which isn't right I believe?
For example, for the bar representing Jan 2017, it takes all issues created before 2017-01-01 that wasn't resolved before 2017-01-01. So an issue created 2016-12-31 and solved 2017-01-15 will count but not an issue created 2017-01-01 and solved the 15th. The latter will not be seen at all, not even in Feb's bar since it was already solved in Jan.

I also realized in the calculation that JIRA not only counts the dates but also the time an issue was created. So you need to take the decimals into account that you get out of the difference both in date and time if you want the figure to match up.

Then the next problem is that the graph can vary over time for already passed months. That seem to be if you reopen issues and get a new resolved time for those issues - then the average age will change.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,316 views 12 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you