How do i use aging from start date field on a Kanban board?

Dilip T K February 22, 2024

I have a JIRA board with different issues each having different start dates - the start date is NOT when I have recorded the issue on the JIRA, it is the date on which the issue started. On JIRA, the issues might have been recorded 1 day later or 1000 days later.

Now I want to create aging based on Current date - Start date and use it on a KANBOARD board swimlane. I want to show different swimlanes as Aging less than 100 days, aging less than 500 days etc as different swimlanes on the Kanban board.

How do I do that?

1 answer

1 accepted

0 votes
Answer accepted
Rebekka Heilmann _viadee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 22, 2024

Hi @Dilip T K and welcome to the community!

The JQL will look something like this: "Start Date" <= -100d

This will show all issues older than 100 days.

If you sort your swimlanes newest to oldest issues top to bottom you don't even have to worry about restricting the Date to something like "between 100 and 500 days old". Your issue will automatically appear in the first swimlane it matches. Therefore if you have

First Swimlane = "Start Date" <= -1000d
Second Lane = "Start Date" <= -500d
Third Lane = "Start Date" <= -100d

An issue that is 1004 days old will be in the First lane, an issue that is less than 1000 but more than 500 days old will be in the second and so forth.

If you're new to setting up Swimlanes here is the official documentation: Configure swimlanes | Jira Software Cloud | Atlassian Support

Dilip T K February 22, 2024

Thanks for the prompt response Heilmann. I have set up the following swimlanes and every record seems to go to the Start Date <= 3650d swimlane. Any ideas on why this may be happening?

JIRA aging.jpg

 

Dilip T K February 22, 2024

Ignore my comment Heilmann - noticed a typo. Thanks for your super tip. Issue resolved.

Dilip T K February 22, 2024

And apologies for addressing your by your surname, Thanks Rebekka. I need to get a coffee!!!

Rebekka Heilmann _viadee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 23, 2024

Obviously me too - the order you chose (oldest to newest) is the correct one. So largest to smallest number top to bottom like in the screenshot gives you the correct results ;) well done! -> I edited my original reply so folks aren't confused.

Like Dilip T K likes this

Suggest an answer

Log in or Sign up to answer