Getting timeline (transition) analytics from Jira?

Question

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?

Emre Toptancı [OBSS] · Answer

Hello Chad,

For time and date related metrics, you can use Timepiece - Time in Status for Jira. 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

Julia Denys [SaaSJet] · Answer

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.

Chad McGregor · Answer

Thank you @Jack Brickey