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

Getting timeline (transition) analytics from Jira?

Hello All,

 

I am looking for a way to get metrics like the following:

 

  • Bug tasks created per sprint

  • Avg bug subtasks per story

  • Time between create and close time on a bug.

  • Time between ‘ready’ and closed (as done) on stories.

  • Defects found in production per release.

  • Defects found by clients per release.

  • Epic burndown charts

  • In-progress items per epic (shows what the team is working on)

  • Items that have been in more than 1 sprint.

Most of these types of data points are drawn from transitions, and i know they can be accessed via some BI tool add-ins... but Marketplace requires i purchase licenses for my entire company when only ~10% of these users will need access. I can't justify paying 10x more than my need.

 

Could someone help with options?

3 answers

0 votes
Jack Community Leader Sep 23, 2019

unfortunately, w/ that level of detailed stats you will need an addon. You mentioned EasyBI. You might also look at Time in Status. I haven't used but I have seen where many others do and it is a wee-bit cheaper.

A couple of OOTB thoughts that would need a fair amount of work I expect:

  1. create custom date fields and edit the transitions desired and using a post function to update custom field use %%CURRENT_DATETIME%% to timestamp the transition
  2. export data to Excel and use it to calculate much of what you are looking for

Some of what you want I think is there using Dashboard gadgets but not the time in status part.

Hello @Chad McGregor

Yes, you might look at Time in Status for Jira Cloud, this add-on has a lot of functionality that you are looking for:

  • it has advanced filtering by sprint, project, filter, report, label, and assignee (also by issue creation, update, and resolution date);
  • you can generate a variety of reports - Time in Status, Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status Count, and Transition Count;
  • you can view your data as charts directly in the application - pie, bar and area charts;
  • you can export the data both as excel file and charts for further analysis.

This add-on has more metrics to offer that I think might be helpful for you.

Hello Chad,

For time and date related metrics, you can use Time in Status by OBSS. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can report how much time each issue spent on each status, each assignee or even each user group. (useful for calculating lead/cycle times and identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting things like reopen counts). You can also list the status entry/exit dates.

You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours. 

Also add system or custom fields as columns to your report and customize the view format of durations.

All data can be exported as XLS, XLSX, CSV.

Emre Toptancı

OBSS

Emre Toptancı -OBSS-

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

261 views 1 2
Join discussion

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