How to find out the average age of the backlog items in your project backlog

[Lauren Maguire]

I need to file a report on the average days of tickets in my backlog that includes 

the average age of the backlog items in your project backlog. I can't seem to find any support online on how to do this. 

[Rahul_RVS]

Hi @Lauren Maguire 

Welcome to the community !!

If you would be interested in a mktplace app for this requirement, you can try out

Time in Status Reports 

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. You can also extract trends analysis and add that as a dashboard gadget too.

The Avg Time in Status Report will meet your use case to track the avg time the issues are spending in a particular state. Do give it a try.

More details here.

Disclaimer : I am part of the app team for this add-on

[Valeriia_Havrylenko_SaaSJet]

Hello @Lauren Maguire  👋
Welcome to the Atlassian Community!

Also if you are open to try a marketplace solution Time in Status can be a great solution. You can easily measure average age of the backlog items in your project backlog. For this just:

1. Choose Average Time Report 
2. Filter by Project or JQL etc.
3. Filter issues 
4. Get you report.

Also look into Time Metrics Tracker | Time Between Statuses.  Add-on breaks down transition times between statuses in a more straightforward way, making it easier to track your team's efficiency and spot bottlenecks. Plus, it provides flexibility with exporting data and setting custom time metrics. 

For get average age of the backlog items in your project backlog add-on just:

1. Filter by Project or JQL etc.
2. Filter Date Ranges
3. Get you report.

Add-ons developed by my team.

See you! 👋

[Danut M _StonikByte_]

Hi @Lauren Maguire,

Welcome to Atlassian Community!

I'm afraid this is not something that could be done using Jita's native reports or tools. Most likely you will need an app from Atlassian Marketplace.

If you are willing to try an app, our Great Gadgets app offers some gadgets that can be helpful for your use case.

WIP Aging Chart gadget - Displays the issues from a filter/JQL in a plot chart by their age along with the overall average age. Optionally, you can set a threshold to easily identify the ones that takes longer than expected (the red-colored ones).

By hovering a dot (issue in the chart) you will find info about it (age).

On its Data tab, this gadget can display a report with all the issue from the filter and their age, which can be exported in CSV. 

Very helpful could be also the Time in Status gadget offered by the same app, which can calculate the average time a status (like ToDo), representing the average age for the backlog items.   

See more about these gadgets in this article: https://community.atlassian.com/forums/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

If you need any help with the configuration of these gadgets, feel free to contact support@stonikbyte.com at any time. 

Danut.  

[Lauren Maguire]

Ah amazing, thank you so much for that. 

[Bill Sheboy]

Hi @Lauren Maguire -- Welcome to the Atlassian Community!

There is nothing built-in to do this, and the possible workarounds depend upon how often you need it and willingness to spend time / money...

• need this one time
  • export the issues to a spreadsheet and perform the math there
• need this often
  • have money to spend
    • investigate the Atlassian Marketplace for addon features for JQL calculated fields, reporting, dashboard gadgets, etc.
  • have time to spend, and there are fewer than 100 issues involved
    • use an automation rule to calculate the value and send a message / email with the result

Kind regards,
Bill

[Lauren Maguire]

Thank you :)