Changing card colours based on turn around time for Defects

[Ajay_Chipalkatti]

Hi,

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.

Thanks

[Jack Brickey]

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