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

Changing card colours based on turn around time for Defects


I am trying to create a query where I can change card colours based on turn around time (for Defect management.)

So for example, if a P1 issue TAT time is 5 days and if a team has taken more than 5 days to resolve the issue, the card colour should go Red. This is to create easy visual indicators to show to the teams where they have exceeded TAT times for Defects.


1 answer

0 votes
Jack Community Leader Sep 11, 2019

there are two pieces to this this. 

  1. you have to figure out how you are going to manage TAT/SLA in Jira. Assuming you have a solution already and you have some custom date field (let's call it "TAT-date") that represents the due date/time then you can achieve #2.
  2. in board settings under card colors screen you can set up queries like below. at least i think this is accurate, tweak to meet your requirements
    • red - TAT-date <= startofday() and resolution is empty
    • yellow - TAT-date <= startofday(-1d) and resolution is empty
    • green - TAT-date <=startofday (-2d) and resolution is empty

Suggest an answer

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

Jira Cloud for Google Sheets: Automatically Refresh Your Data!

Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...

7,364 views 33 29
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