Control Chart data (time in a column) in Search result

[aleksey.shishkin]

We are using Jira Cloud for our Kanban project. Control Chart report shows the length of time a work item spent in each column in our Kanban board and a total time ("cycletime").  

When I search for issues I'd like these information to be in search results. I tried to add columns (Search issues page -> button "Columns" -> search column) to the Search results, but there are no columns named like our Kanban board columns and there is no "cycletime" column too. 

Why these data is available in Control Chart, but not in Search results? Can I somehow add it in Search results?

[Earl McCutcheon · Accepted solution]

Hello @aleksey.shishkin ,

The Cycle times generated by the control chart do not live in a field directly so the value cannot be returned as a direct data point for a JQL search but are calculated as a function provided in the report.

A full list of the avaliable fields can be seen in "Advanced searching - fields reference"  but to get the cycle time in the manner you are looking for you would need to look into add-ons that provide this additional function,  Check out the following thread that discuss several add-on apps that can do this:

• https://community.atlassian.com/t5/Jira-questions/How-do-I-get-cycle-times-time-in-a-status-from-Jira/qaq-p/761203

Regards,
Earl

[Zoryana Bohutska _SaaSJet_]

Hi @aleksey.shishkin 

Also, you can get Cycle and Lead time with add-on Time Between Statuses.

It calculates date after configuration where uses can set start, pause and stop statuses. You can monitor status to status duration data about each ticket in іssue view panel. Additionally, now is available ability to configure time limits and set email notifications about overdue issues. 

Holp it helps.

[Emre Toptancı _OBSS_]

Hello Aleksey,

This will be a similar answer to your other question but again, if you are interested in a ready-to-go solution, our team at OBSS created Time in Status 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, each assignee or even each user group. (useful for identifying bottlenecks in your process). You can consolidate multiple status durations into a report column (useful for calculating metrics like lead/cycle times). 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.

Using Time in Status by OBSS, 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