'Average Time in Status' for Unresolved issues

[Matt Davis]

The current Dashboard Gadget 'Average Time is Status' is for Resolved issues only.  Is there an option for this gadget for unresolved issues?

[Bill Sheboy]

Hi @Matt Davis  -- Welcome to the Atlassian Community!

Short answer: no, not with any out-of-the-box Jira features.

Longer answers:

• There are markeplace add-ons you may purchase for time in status measures.  Some are just dashboard gadgets and would probably meet your needs, and some are full featured analysis products.  Give it a minute and several vendors will probably respond to your post.  ;^)
• You could build your own using automation rules and custom fields.  We are doing this and using a simple dashboard gadget add-on.
• You could use the REST API to pull data (or webhooks to push data) into another tool for reporting
• There are some templates for the Jira Excel Add-in (or Google Sheets) which allow you to pull data for this type of reporting.  I haven't used any of those templates.

To move forward, I recommend jotting down some notes and what you want, and what you would do with that information if you had it.  That will help you evaluate what approach you want to take.

Best regards,

Bill

[Zoryana Bohutska _SaaSJet_]

Hi @Matt Davis

One of the solutions from the Atlassian marketplace is Time in status for Jira Cloud app (created by my team).

It lets you set gadgets with time in status, average time in status, and other reports on Jira Dashboard.

You can view data in tablet and chart views.

Using its build-in JQL filter you can select a list of unresolved issues.

Hope it will help you

Regards

Zoryana

[Daniel Ebers]

Hi @Matt Davis
probably we are using it wrong ... but when setting up the gadget at least in our Cloud instance it was not restricted to resolved issues but instead it shows the following:

Probably you are looking for something different, though.

Regards,
Daniel

[Peter Yoon]

Hi Daniel,

If you check the sentence under the visual, it specifies that the chart shows all resolved issues over the past 30 days.

I have an issue with my chart. The In Progress (Open) metrics aren't displayed. I am not sure if you see this issue too.

Best,
Peter

[Daniel Ebers]

Hi Peter,

you are right - then this will be of no help. There are some ideas from Bill above, maybe they match your requirement.

It's a bit special the chart only shows when the issues got resolved - apparently it was the case back when I tried it on our cloud instance.

Cheers,
Daniel

[Emre Toptancı _OBSS_]

Hello @Matt Davis ,

For an automated solution that offers great flexibility and details, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time. 

You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the total InProgress time per Epic, or average Resolution Time per issuetype).

The app has dashboard gadgets and any valid JQL can be used for reporting so you are not limited to just resolved issues.

 

 

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.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
• Export your data as XLS, XLSX or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets (released for cloud, server&DC gadget coming soon)

https://marketplace.atlassian.com/1211756

EmreT

[Bloompeak Support]

Hi @Matt Davis ,

For an automated solution, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

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. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try.

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