Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Sort swimlanes by days in status

Anton Schneider
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 7, 2022

We want to move the issues upwards the column depending on the time spend in that status. 
Each status has it's own column. 

 

We use "days in Column" to display the red dots but i cant find the possibility to sort that column by "days in column" or find a documentation to that. 

 

 

2 answers

1 vote
John Funk
Community Champion
July 7, 2022

Hi Anton - Welcome to the Atlassian Community!

I assume you are using a Company-managed project - is that correct?

If so, you can probably write a query for the swimlane such as 

project = ABC and status changed to "In Progress" after startOfDay(-7)

You would change the status to your status, of course, and what ever amount of days in place of 7 for how many days it should move into this swimlane.

John Funk
Community Champion
March 11, 2023

@Anton Schneider  - Did you ever figure this out? 

0 votes
Aron Gombas _Midori_
Community Champion
July 7, 2022

I don't it is possible that way.

As a workaround, I could imagine that you introduce a custom field (Number type) which calculates the time in the issue's current status.

Then you define swimlanes like:

  1. "100+" and set up a JQL for this which tests if the custom field value is >= 100
  2. "75-100" and set up a JQL...
  3. ...

Do you get the idea? 

(Your issues should start in the last swimlane and move upwards as the field value increases. You can configure this approach to your desired granularity by increasing the number of swimlanes.)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events