Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

'Average Time in Status' for Unresolved issues

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

4 answers

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

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

Like # people like this
0 votes
Daniel Ebers Community Leader Feb 14, 2021

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:

grafik.png

Probably you are looking for something different, though.

Regards,
Daniel

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 Community Leader Aug 08, 2021

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

0 votes

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.

tisCloud_StatusDuration_Report.pngAverageStatusDurationByComponent_Data.png 

tisCloud_IssueView_Chart_StackedColumn.png  AverageStatusDuration_Chart.png

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

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Confluence Cloud

🎨 Add some visual life to your templates

Hi Atlassian Community, My name is Avni Barman, and I am a Product Manager on the Confluence Cloud team. Based on feedback from you, we are giving admins more power to create templates that a...

151 views 1 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you