Is there a gadget to graph out average time to resolution over a period of time?

[todd joyce]

My team handles elevations for our product.  I would like to show how quickly we are closing/resolving elevations and how that turnaround time fluctuates over the past month, year, multiple years...

Is there a gadget available in Jira that would capture that?

I currently use the gadget for Issue Filter Formula to display the average number of days an elevation is open but this only shows the current average and not  how this may fluctuate month to month, week to week, day to day.

[Valeriia_Havrylenko_SaaSJet]

Hi @todd joyce  👋

Welcome to the Community!

Unfortunately, there is no way you can find with native gadget, but you can achieve it with marketplace app such as Time in Status.
You can display the average resolution time on the dashboard by List View. 

Also you can display the average resolution time on the dashboard by Chart View. 


 Here is the configuration menu, so you can configure your report precisely for your needs.

And with Columns, you can choose statuses that you want to calculate and unite them into Status Groups to calculate the total average time for metrics such as Resolution Time, Cycle Time, and Lead Time.

Add-on has a 30-day free trial version and free up to 10 users.
Hope it helps 😌

[Gizem Gökçe _OBSS_]

Hello @todd joyce ,

Welcome to the community!

As far as I understand you are ok to use a marketplace app for your needs. So in this case Timepiece - Time in Status for Jira which is developed by my team at OBSS, is the tool I would highly recommend. It is available for both Jira 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. In your case it is efficient to calculate the average resolution time per year, month etc. The ability to group by parts of dates (year, month, week, day, hour) is particularly useful here since it allows you to compare different time periods or see the trend.  (please see the screenshot below)

It is possible to create charts for all reports you receive from the app, both for the entire report and for specific rows/data sets in the report, and display these charts on the dashboard.

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. 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

Also, if you are interested in more detailed information on how to set up metrics and use  Time in Status, please consider reading my article below. 

Revealing Operational Excellence: Identifying Bottlenecks through Metrics like Cycle Time, Lead Time

Kind Regards,

Gizem

[Danut M _StonikByte_]

Hi @todd joyce,

You mentioned the Issue Filter Formula gadget; this means that you have our Great Gadgets already installed. Be aware that our app offers some additional gadgets that will address your need.

For example, the Cycle Time Trend Chart gadget will display the average time to resolution for your issues, grouped by time intervals, along with the trend line. 

Very helpful can be the Histogram Chart gadget, Control Chart gadget or Advanced Issue Filter Formula gadget offered by the same app.

Take also a look over this: https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Hope this helps. If you have any questions, please contact support@stonikbyte.com.

Thank you,

Danut Manda 

[Mehmet A _Bloompeak_]

Hi @todd joyce

Welcome to the Atlassian Community!

You can use cycle time (the time it takes for the team to start working on an issue and complete it) and/or lead time (the time interval between the moment an issue is requested to the moment it is completed) reports to get what you need. For these reports, 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.

• Cycle Time: You can have a look at Cycle Time by Assignee, Cycle Time by Project, Cycle Time for Each Issue, Cycle Time by Issue Resolution Week, Cycle Time by Issue Creation Month reports as examples.
  
  
• Lead Time: You can have a look at Lead Time for Each Issue, Lead Time by Sprint, Lead Time by Component reports as examples.

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.

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

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

Hope it helps.