Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

2 answers

1 accepted

0 votes
Answer accepted

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:


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.

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ı


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,499 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you