In front of each expression (or expression group) an expansion icon (a box with a ' + ' ) is shown. Clicking the icon opens up underlying sub-expressions or attribute expressions.
If you add your expression to the"Text Color" option it should highlight all values <='08:00' with the color red.
If you want to edit the color I would recommend using RGB(xxx,xxx,xxx) instead where xxx are the different RGB values.
I was wondering if you could kindly help me with something else, visual cue based
The information below alrday has a comma in it, so If I want to use and IF and ELSE expression, I would have to many commas
(Time(fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440, 'hh:mm')<='04:00',
RGB(255, 0,0), RGB(255, 255, 255) ,
RGB(128, 0,0), RGB(128, 128, 128)
In addition, how do I format the '04:00', do I simply write 4 to get it match my interval in the expression
Any advice is greatly appreciated
Not quite sure what you want to do with the second row of RGB colors. The first is if expression >='04:00' then
RGB(255,0,0) else RGB (255,255,255) Now you need to add another statement with a "OR" or an "AND" statement.
As for the formating you could try removing the ":" from the time format i.e.
(Time(fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440, 'hhmm')<='0400',