How can I report on the following Kanban metrics?

Nathan Hawk May 12, 2023

Note: We are using Kanban board, not Scrum.

  • Cycle Time = Time to completion from start.
  • Lead Time = Time it took to complete from when the issue was created. 
  • Throughput: based on issues count and estimation points.
  • Work Item Age: Especially for In Progress.

I would prefer a built-in solution, but I am open to marketplace add-ons.

4 answers

2 votes
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 14, 2023

Hello  @Nathan Hawk 

As an alternative you can try Time between Statuses developed by my SaaSJet team, which gives you ability to check Cycle and Lead time easily :)

How it looks like:

Знімок екрана 2023-05-09 о 14.37.43.png 

Also you can set the start/stop/pause timers to get Jira time in status data. Determine time limits to highlight overdue issues. And you will be able to send email notifications about warning issues.

After you will be able to export the report as CSV or XLSX files easily.

Add-on has a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌
Valeriia

0 votes
Emre Toptancı _OBSS_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 29, 2023

Hello @Nathan Hawk 

If you are OK with using a marketplace app for this, our team at OBSS built Time in Status for this exact need. It is available for Jira Server, Cloud, and Data Center.  

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee

tisCloud_StatusDuration_LeadTime_with Estimates.png    tisCloud_AssigneeDuration.png

You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per Vertical or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

tisCloud_StatusDuration_LeadTime_Average_TimeGrouped.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. It supports both Company Managed and Team Managed projects for Jira Cloud.

Time in Status 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.

Gadget_AverageStatusDurationByComponent.png  tisCloud_StatusDuration_LeadTime_Chart.png

https://marketplace.atlassian.com/apps/1211756/

EmreT

0 votes
Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 16, 2023

Hi @Nathan Hawk

1. For cycle time, lead time and work item age, you can try Status Time Reports app developed by our team.

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

For more detail, 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.

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

2. For throughput (based on issues count and estimation points), you can try Reports - Charts and Graphs for Jira Dashboard app developed by our team.

Here is our live demo dashboard where you can see and modify sample reports and play with them. For your case, you can create "Number of Issues by Issue Resolution Week"  and "Sum of Story Points by Issue Resolution Week" reports.

For more detail, you can have a look at Reports - Charts and Graphs for Jira How to Videos.

If you are looking for a free solution, you can try the limited version Reports - Charts and Graphs for Jira Dashboard Free.

Hope it helps.

0 votes
Craig Nodwell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 14, 2023

Hi @Nathan Hawk there is no built in solution for this.  You could build this out yourself with a marketplace app like scriptrunner, or have it out of the box with the maketplace app Time In Status.

Suggest an answer

Log in or Sign up to answer