Colour highlight rows dependent on conditions/critiera

[#1]

Hi,

I have a straight table that looks as below, and I need to add some conditions and (if possible) highlight the rows Green/Red/Amber dependent on the following criteria. If it is not possible to highlight the rows, perhaps add a new column as 'RAG Status' and have G/R/A inputted depending on the result.

Criteria:

GREEN - Actual Start/End Time is less than 5 minutes of the Scheduled Start/End Time

AMBER - Actual Start/End Time is more than 5 and less than 30 minutes of the Scheduled Start/End Time

RED - Actual Start/End Time is more than 30 minutes of the Scheduled Start/End Time

Table:

Name	Description	Scheduled Start Time	Scheduled End Time	Actual Start Time	Actual End Time
Run1	ABC	07:30:00	07:45:00	07:34:00	07:46:00
Run2	123	18:00:00	18:20:00	18:15:00	18:24:00
Run3	XYZ	09:45:00	10:05:00	09:55:00	10:22:00
Run4	456	12:05:00	12:30:00	12:05:00	13:08:00

So in this instance, the results would be as follows:

Run1 - Green - Times are within the criteria

Run2 - Amber - Starts more than 5 minutes after Scheduled Start Time

Run3 - Amber - Starts and Ends more than 5 minutes after Scheduled End/Start Times

Run4 - Red - Ends more than 30 minutes after Scheduled End Time

Thanks and kind regards,

Tristan

[#2]

No unfortunately not, we need them the same as we have a lot of metrics on the historical data

[sunny_talwar]

But you want to check it for 25/06/2015? Start Date or End Date from both tables?

[sunny_talwar]

We can restrict the join table to be for the current date, so that the join happens only for current dates only

[#5]

Just the Start Date would have to be today; maybe with the Date(today()  function we could restrict it so it's only ever looking at the current date.

Is it possible to have a second join to do that? So that I can still use the current join for the historical data, and a restricted join for the current day's data?

[sunny_talwar]

I have a meeting, will catch you after one hour. Sorry about that

Best,

Sunny

[#7]

Thanks for all the help with this Sunny. I need to leave my office now (and out tomorrow) so I'll check in again on Monday.

Really appreciate all the help with this!

Best,

Tristan

[sunny_talwar]

Monday is good

Have a good night

Best,

Sunny

[#9]

Good morning Sunny, hope you are well.

Is there any way we can restrict the join table to be for today's date only (for both Start/End Date)?

Best,

Tristan

[sunny_talwar]

Do you want to restrict the whole application for today's date or do you want this calculation for today's date only is the question I have for you Tristan?

[#11]

Just this calculation only if possible - as we use the join for historic metrics at the moment. Could it written into the NewTable If statements perhaps?