How can I set up a Jira dashboard that shows cycle time for all Stories and tasks in a sprint

[Graeme Doyle]

How can I set up a Jira dashboard that shows cycle time for all Stories and tasks in a sprint? The team is  having a terrible time with Stories taken too long and spilling into next sprint. I want to run a retrospective but I need to show then cycle times per issue type. Any help would be fantastic.

[Valeriia_Havrylenko_SaaSJet]

Hi @Graeme Doyle  👋
Welcome to the Community!

If you consider installing third-party add-ons, option for you can be Time in Status. You can get various real time reports with add-on. To get cycle time (total duration) just choose right statuses for calculation and you will be all set!

Add-on developed by my team. You can also book a live demo - we'll show you the application inside out and answer all your questions.

 I hope this helps 😊

[Gizem Gökçe _OBSS_]

Hello @Graeme Doyle ,

For your needs, I can recommend Timepiece - Time in Status for Jira , the oldest and the most comprehensive "Time in Status" solution in Atlassian Marketplace, which is built by my team at OBSS. It is available for both Jira Data Center and Cloud.

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

You can easily use your predefined sprints as filter type and you can create reports calculated specially for your sprints.

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total cycle time per scrum team or average resolution time per issue type.

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.

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

Visit Timepiece - Time in Status for Jira to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Madhu_RVS]

Hi @Graeme Doyle 

You can use Jira Rest API's to pull this data from issue changelogs. Or You can create your own custom fields and apply Jira automation to populate those. 

Alternatively if you are open to try a mktplace app, pls do take a look at 

Time in Status Reports 

With this app you generate time in status for multiple issues with multiple filter and grouping options. You can also group your statuses to define you cycle times. The app can easily be added as a dashboard gadget.

More details here.

Disclaimer : I work for the vendor who built this app

[Hannes Obweger - JXL for Jira]

Hi @Graeme Doyle

welcome to the community!

As you can see from the previous answers, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their reporting needs. 

If a Marketplace app is an option for you, I think you might like the app that my team and I are working on, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including an issue's time between created and resolved, time in [status], or time between [status] and [status].

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

As every JXL sheet is powered by a JQL statement, you have full control over which issues you want to see in your sheet.

Any questions just let me know,

Best,

Hannes

[Josh Costella]

Hi @Graeme Doyle 

Apologies that you are getting spammed with nothing but plugin recommendations. 

From a process perspective, I don't think cycle time is the right thing to measure for your use case. If you are doing sprints, the cycle time is the length of the sprint. The stories are either complete or they're not. 

The type of report you are asking for doesn't tell you the root cause. Your sprint reports in your board give you a breakdown of everything that was complete, incomplete, added, and removed during the sprint. From there, you can start to investigate. 

I would interview the team/assignee, ask why they couldn't get the story complete for the sprint. Is the team taking too much on? Are you using story points or hours as an estimate? Are stories getting added mid-sprint? Is the team working on items outside of the sprint? Are the stories not defined well enough with clear deliverables? These are all questions that need to have answers in order to get to the root cause of why the team is rolling stories to additional sprints. 

[Danut M _StonikByte_]

Hi @Graeme Doyle,

Jira does not offer a cycle time gadget. But you can visualize the cycle time for the issues in your sprint by using the Control Chart report available in your Scrum board. 

Unfortunately this report does not offer a data table, so you will have to hover each issue in the chart to visualize the cycle time in the tool-tip. 

If you want something better, you should search for available app on Atlassian Marketplace.

If you consider the idea of using an app, our Great Gadgets app offers many gadgets that allow you to measure the cycle time or time-in-status for the issues in your sprint. See for example, the Control Chart gadget: 

It has the advantage of showing a Data tab with all the issues and their cycle time, which you can export in CSV and discuss it further with the team in the retrospective meeting. 

   

Hope this helps.

Danut.

[Mehmet A _Bloompeak_]

Hi @Graeme Doyle

If you prefer to use a marketplace app, 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.

You can use cycle time(the time it takes for the team to start working on an issue and complete it) or lead time(the time interval between the moment an issue is requested to the moment it is completed) reports to monitor the productivity of the team, analyze and understand the dynamics behind it and take necessary actions. Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Cycle Time for Each Issue and Lead Time for Each Issue reports.

For further details, 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.

App Features:

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

If you have any questions, feel free to schedule a demo with us.

Hope it helps.