Report to show exceptions based on SLA

Content

Hi,

We're looking at creating a report to show all incidents, coloured by SLA state. So for example if the incident is less than 2 days old, black font. Between 2 and 3, show green, 3 and 4 show orange. More than 4, show blue.

So one exception is as follows:

if(date_diff(sysdate(),incidents.created)/(3600*24)>3,if(date_diff(sysdate(),incidents.created)/(3600*24)<=4,1),0)

This will be for the orange status. However the SLA is for weekdays, 8am to 5pm. If someone logs an incident at 5pm on Friday, by Tuesday it will be Orange, when in theory, it should only turn Orange on Thursday.

I've messed with the following and this outputs stuff correctly but I can't do an exception based on it.