Report on time to complete bugs by priority

Question

I want to create a report to review how long it takes for bugs to go from creation --> done, and separated by priority. We have SLAs for each priority status and I want a quick report to glance at each month to make sure we're meeting our SLAs. (without a plug-in would be great!)

Aron Gombas _Midori_ · Answer

If your business people are familiar with Excel, you can export the "Time in status X" data to Excel (report samples):

...and it comes with pivot charts that you can easily re-configure:

The whole report is generated by Better Excel Exporter based on an Excel template which you can further customize.  For example, you could implement a test which compares the "Time in Status X" value to the one defined in your SLA and mark the issues that didn't meet it.

(Discl. it is a paid and supported app developed by our team. Free for 10 users.)

Hannes Obweger - JXL for Jira · Answer

Hi @Nina Pittas,

welcome to the community!

If you want to use Jira's built-in views, the only thing I can think of is to use Jira Automation to do the calculation yourself and store the result into a custom field, and then view the custom field in a Jira report. I can't advice on the details, but this article should be a good starting point.

Alternatively, as you've surely noticed by now, there are a number of apps available in the Atlassian Marketplace that operate in this space. Just be aware that you can trial any app for free for 1 months, and depending on the size of your site, it may be free forever - so if a Marketplace app is an option for you, perhaps try a few and see which one solves your use case best.

On this note, here's another app that you might like: 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 number of so-called history columns that aren’t natively available, including time in [status], time between created and resolved, and many more. You can also group your issues by any issue field, including priority.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and group them by any issue field, including the priority. You can also them across JXL's other advanced features, such as support for (configurable) issue hierarchies, sum-ups, or conditional formatting.

Disclaimer: I work on JXL.

Any questions just let me know,

Best,

Hannes

Vitaly_Berezovsky_SaaSJet · Answer

Hi @Nina Pittas

For these purposes, I can recommend the SLA Time and Report from the Atlassian Marketplace. This add-on has great reporting functionality.

That's an example how to set the reporting function you need:

1. Create three new SLAs for the same Project, using the same Work schedule and Start/Pause/Stop conditions as the previous configurations, excluding the Reset SLA – leave it unconditional.

If you have teams in different time zones and need to calculate SLAs for each group, you can add a Location condition – a custom field value which allows teams to select their time zone on the ticket.

2. Set the time goals and Limit Exceeded actions for each SLA configuration. In our example, it will be notified via the SLACK channel about Breached time limits.

Breached time for Medium priority

Breached time for High priority

Breached time for Highest priority

3. Save all SLA configurations.

4. Finally, select all SLAs as the filter for issues. You can see the time spent on the SLA time goals and identify any that were exceeded or breached through the table report or charts.

That’s all! Enjoy your work without exceeding the resolution and response time.

The application has a 30-day trial period and is free for small teams (up to 10 users), so you can check how well it suits you. My team developed it, so our support can help you with the settings.