How do you calculate Lead Time & Cycle Time?

[Doug Waddell]

We are on JIRA v7.10.0 and it seems that the Control Chart is not providing the information we need to calculate lead & cycle time because it uses a rolling average based on a number of issues, not the actual average time for all items in that sprint.

https://confluence.atlassian.com/jirasoftwarecloud/comparing-different-methods-of-calculating-the-rolling-average-on-the-control-chart-777002680.html

Why am I seeing a rolling average drastically changes across a 10 day sprint?  I have changes of 5+ days in the rolling average overnight.  I get that you might want the default setting to be based on a sampling of issues, but if I change to criteria and ask for a customer date range...why can I not get an average of ALL issues?  Please save your time if you answer is 'buy my add-on...', Jira should be able to provide this functionality out of the box.

[Mehmet A _Bloompeak_]

Hi @Rafael Macedo ,

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.

[joeWeiss]

I like to look at the individual issues to measure those values.  Lead time is easy to find by running a query for the issues you want to view and make sure that 'created' and 'resolved' dates are listed in the columns that you want to export.

Cycle time is a bit trickier.  If you are able to create a custom filed that captures the time an issue goes into 'working' status, then you can include that value in your export and then you can view cycle time per issue.

Lead Time = created -> done

Cycle Time = working -> done

-joe

[Mouli]

Hi @[deleted] , Thanks..

Helps to a certain extent..

But Jira being the defacto tool for many "Agile" orgs, isn't this something that should be available by default? Or is Jira not built for Kanban?

[Rafael Macedo]

I`d also like to know if there's an automated way to generate this info. 

Tks 

[Emre Toptancı _OBSS_]

Hello @Rafael Macedo ,

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

The app has Custom calendar support that your are looking for. This feature enables you to get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

Finally, the app has History Trim feature. This feature allows you to report on a subsection of issue histories instead of the whole history. Very useful when you want to focus on changes made during sprint or project phase.

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

[Rafael Macedo]

@Emre Toptancı _OBSS_  can you help me find in the website whats the functionality enables this feature? 

In the link below, I couldn't find it

https://www.atlassian.com/software/jira/pricing?tab=cloud

[Emre Toptancı _OBSS_]

Hello @Rafael Macedo ,

Time in Status is not part of standard Jira offering. It is available as a separate app on Atlassian Marketplace. You can see and install the app from the Marketplace link below:

https://marketplace.atlassian.com/1211756

Once it is installed on your Jira, you can access the app using the Time in Status link in the main Jira menu.

EmreT

[Rafael Macedo]

OMG...that was on my face....lol.

Tks a lot.