How to Create a Jira Dashboard Widget for “Avg. Time to Resolve Bugs” (From Creation to Resolution)?

[Mohsen Nasiri]

Hi Atlassian Community,

I am looking for a way to create a Jira dashboard gadget that displays the average (or even better more aggregation options) time it takes for bugs to be resolved—from the moment they are created to when they reach a resolution state (e.g., Done, Implemented, Released, or any other final resolution state). Ideally, I would like this to be visualized per day or week to track trends over time.

Current Setup:

1.We are using Jira Cloud.

2.We have the following apps installed:

• About Requirement Yogi

• ActionableAgile

• BigGantt

• Component Management

• Refined Sites

• Rich Filters

• Team Insights for Jira

• Worklogs

• Xray

• Zeplin for Jira Settings

What I Need Help With:

•Which Jira gadget or app can best accomplish this? Does Jira natively support this, or do I need an app like “Rich Filters” or “ActionableAgile” to achieve this view?

•What JQL filters or calculated fields do I need to create? Should I create a custom field to track resolution time?

•How do I set up the dashboard to visualize it by day or week? I want to track how long it takes for bugs to be resolved over time.

- Ideally it would be best if the solution is using the Rich Filter app's set of widgets since we are widely using that.

If you have experience setting this up or have suggestions on best practices, I’d really appreciate the help!

Thanks in advance.

[Rahul_RVS]

Hi @Mohsen Nasiri 

Welcome to the community !!

To track time in status, as an alternative, 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.

More details here.

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

[Ayça Erdem_OBSS_]

Hello @Mohsen Nasiri 

Welcome to the community.

You can use Rich Filters to create calculated fields and visualize key metrics like average resolution time over time. With its time series gadget and filtering options, you can track trends and analyze performance based on different time frames.

However, if you ever need it I can recommend Timepiece  -Time in Status for Jira , the oldest and leading "Time in Status" app in Atlassian Marketplace, which is built by my team at OBSS. It is available for Jira Server, Cloud, and Data Center.  

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee. In Status Duration Report you can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total cycle time per kanban team or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

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.

Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily. 

Visit Timepiece  -Time in Status for Jira  to explore how our JIRA add-on can revolutionize your metrics measurement process. Enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Ayça

[Pasam Venkateshwarrao]

Hi @Mohsen Nasiri 

To simply get the issues "that were resolved in the last X hours" you can use a JQL like:

project = ABC and status = Resolved and status CHANGED TO Resolved AFTER -48h

If you want to see how long it took for issues to get resolved, you will need to use an SLA app or a reporting app.

In case you are OK with using a marketplace app, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud, and Data Center.

Thanks

[Marc - Devoteam]

Hi @Mohsen Nasiri 

Welcome to the community.

This is not natively in Jira.

You could track this nu using automation. You will need a custom date/time field to store the result

Use smart values in automation, see jira-smart-values-date-and-time/#Date-difference 

And use the creation date and resolved date as starting points.

This field can be used in filter results on a dashboard.

Otherwise look at the marketplace for apps, you could try multiple apps.

You could start with the app that is completely free, Status Time Reports Free - Time in Status"