7 answers
Hello @Lauren Maguire ,
Welcome to the community!
You can easily get the average age of backlog items using Timepiece - Time in Status for Jira. Duration Between Statuses report lets you track how long each issue has been open by measuring the time from creation to today. By filtering for backlog items and enabling the average calculation, you can easily see how long issues have been waiting.
Configure the Duration Between Statuses report to measure the time from issue creation to today.
Use the following JQL filter to focus on backlog issues (those without a sprint)
project = "ATeam Scrum Project" AND Sprint = empty
The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. Reports are available via the reporting page, dashboard gadgets, and issue view screen tabs, with both data tables and charts. Timepiece also offers a REST API for seamless integration and supports CSV/XLS exports.
Timepiece is available for both Jira Cloud and Data Center. Let me know if you’d like more information or assistance with your reporting needs!
Hope it helps,
Gizem
welcome to the community!
An issue's status changes are captured in an issue's issue history, which you can access from the issue view in Jira or via Jira's REST API. From these status changes, you can calculate the time that an issue spent in a particular status - however it can be quite tricky to do that by hand.
That's the reason why a lot of users rely on solutions from the Atlassian Marketplace to do that for them. E.g., you may want to have a look at the app that my team and I are working on: JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren't natively available, including the time in [status], time between [status] and [status], and many, many more.
This is how it looks in action:
As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. Of course, you can also export your data to Excel or CSV in just two clicks.
Any questions just let me know,
Best,
Hannes
Welcome to the community !!
If you would be interested in a mktplace app for this requirement, you can try out
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.
Disclaimer : I am part of the app team for this add-on
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:
- Choose Average Time Report
- Filter by Project or JQL etc.
- Filter issues
- 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:
- Filter by Project or JQL etc.
- Filter Date Ranges
- Get you report.
Add-ons developed by my team.
See you! 👋
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.