Highlighting the JIRA stories in Kanban board which are at risk

Question

Hello,

We use Kanban board and I am trying to understand if there is a mechanism for highlighting the stories that are at risk. For example, we have a field called: QA Target Completion date (Custom field) and our release date is another custom field. IF the QA Target complete date  > current date, then the story should be tracked as RED, if the QA target completion date is nearing the current date, then it should be YELLOW. Is there a way to do this?

I also use the Confluence dashboard. Even if I can somehow highlight this in confluence, it would be helpful.

Robert Yocum · Accepted Answer

I believe you can do this in board settings > card colors. Once you navigate there, choose Queries from the 'Colors Based On' select list.

Your query will be something like "QA Target complete date" < now() for the red color.

For the yellow color, use "QA Target complete date" < now("+5d"). This would the color to be yellow if the target complete date is 5 days away. Adjust as necessary.

There are many other time based functions you can select from as well.