Creating a Dashboard for WOW resolution time

[Ahmed Dahy]

Hi There,

Might be a simple one, and I am not an expert with Jira.

I am assigned a task to create a Dashboard to show the average resolution time of a ticket per week.

The conditions are as follows:

1- We have a custom field which is Priority, we need 4 Gadgets for each priority.

2- I believe we can calculate the Average time from the Created and resolved timestamps, however, it needs to be done on week over week view.

[Rahul_RVS_Support · Accepted solution]

Hi @Ahmed Dahy 

Welcome to the community !!

OOTB Resolution Time dashboard gadget and Control Chart are limited in features.

If you would be interested in a mktplace app, you can try our addon:

Time in Status Reports 

The add-on provides the week on week status duration. And you can combine your statuses to define your own resolution times.

You can also create a Dashboard gadget out of it with graphs too.

Also there are 20+ reports in the app which help to meet a wide range of use cases.

Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Ahmed Dahy]

@Rahul_RVS_Support thank you so much, I am using it now as we speak

[Emre Toptancı _OBSS_ · Accepted solution]

Hello @Ahmed Dahy

I will point to some built-in Jira solutions and then recommend a marketplace app.

First, you can get such a report using Jira's Resolution Time dashboard gadget. 

Second, if you are using Jira Software, you can use the Control Chart that is available as part of Kanban Board reports.

Both of these reports are built-in but they offer limited details and limited flexibility.

For better flexibility and maximum details, our team at OBSS built Time in Status for this exact need. It is available for Jira Server, Cloud, and Data Center.  

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee. 

   

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 in-progress time per Vertical 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. It supports both Company Managed and Team Managed projects for Jira Cloud.

Time in Status 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.

  

https://marketplace.atlassian.com/apps/1211756/

EmreT

[Ahmed Dahy]

@Emre Toptancı _OBSS_  I appreciate the answer, thank you so much, I was actually under the impression it was only a gadget, but you pointed out it's an app as well, I will make the maximum use of it.

Thank you so much

[Valeriia_Havrylenko_SaaSJet]

Hello @Ahmed Dahy 

As an alternative , I guess you can try Time in Status for Jira Cloud or Time Between Statuses or developed by my team SaaSJet.

Time in Status for Jira Cloud lets you get Cycle and Lead time by setting Status Groups. You can configure it from your account at the Column Manager with the drop-down list of the statuses. A custom report can be placed on the main Jira dashboard with the special Gadget tool, and you can export data in XLSX or CSV formats.

 

Time between Statuses is the add-on, which measures connections in the workflow, through a transition time in specific issues. You can count Cycle and Lead Time by setting start/stop and pause statuses in the configuration manager. To detail the calculation conditions you should select the first/last transition to/from status.

You can customize your Cycle and Lead Time reports by adjusting the app interface fields such as: Type of Project Date range Time Format Multi Calendar (to configure non-working hours and different calendars.) This add-on also allows you to export data in XLSX or CSV formats.

Add-ons have a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌
Valeriia

[Thiha kyaw soe]

ssein0007@gmail.com

[Ahmed Dahy]

Thank you very much all, much appreciated, I could find that we already have the Time In Status gadget, and I used it to create what I needed successfully.
Much appreciated

[Mehmet A _Bloompeak_]

Hi @Ahmed Dahy

Welcome to Atlassian Community!

For cycle time (the time it takes for the team to start working on an issue and complete it), you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Cycle Time by Issue Resolution Week report.

For more detail, you can have a look at Cycle Time and Lead Time in Jira: Productivity Measurement with Two Critical Parameters article and Status Time Reports How to Videos.

If you are looking for a completely free solution, you can try the limited version Status Time Free.

Hope it helps.

[Danut M _StonikByte_]

Hi @Ahmed Dahy,

This can be easily done with our Great Gadgets app.

One of the many gadgets that it offers is the Cycle Time Trend Chart, which can be configured  to calculate the average time between issue creation and the moment it was moved to a done-category status (resolved). The data can be grouped by one (ore more) week(s), as you want. This is how it looks like.  

The gadget is based on a filter, so you can have 4 gadgets on your dashboard, one for each priority.

This app offers many other gadgets that you will find useful. 

If you have questions, please don't hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut M. 

[Mark Segall]

Hi @Ahmed Dahy and welcome to the community!

Have you tried the Resolution Time gadget?  It supports period breakdown by hourly, daily, weekly, etc.  You would just need to set the source to the appropriate filter.  For example, you could do this for a High Priority resolution time:

project = X and priority = High