How to Calclulate Cycle Time with Query

Question

I am trying to use the query to get cycle time. I am sure I am doing something wrong with my query

project = "ACME" AND status = "In Progress" AND resolutiondate > startOfYear() AND resolutiondate < endOfDay()

Basically, I want to know when a story/Task/Subtask is inprogress to end

Mark Kern [SaaSJet] · Answer

Hi @Ahsan

To the list of tools listed above, you can try one of the following applications:

Time Between Statuses - calculate the Cycle and Lead Time of your Jira issues by setting start/stop/pause statuses

Time in Status for Jira Cloud by SaaSJet - can show the Cycle and Lead Time by grouping statuses.

Hope it helps

Best Regards

Emre Toptancı [OBSS] · Answer

Hello Ahsan,

You cannot calculate cycle time with basic JQL. JQL only does filtering.

Our team at OBSS created Timepiece - Time in Status for Jira app for this exact need. 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. You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours.

All data can be exported as XLS, XLSX, CSV so you can calculate the sum of your desired statuses in a spreadsheet app to get cycle time.

Emre Toptancı

OBSS

Edit on 11 Dec 2019: We recently introduced Consolidated Columns (which display the total duration for a group of statuses) so users now can create columns for metrics like Cycle Time or Lead Time and pick which status durations to include in these columns.

Jack Nolddor [Sweet Bananas] · Answer

Hi Ahsan,

Please have a look to Links Hierarchy - Core, Epic & Portfolio

Regards