Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do you do a color code like below I know how to use?
The numbers are averaged for wait times
Color code in brackets 1 - 5 red 6-8 green 9 and over yellow
example of the expression I an trying to use.
if((Avg(ActualLeaveTime-ScheduledLeaveTime))>0, rgb(255,0,0), RGB(50,230,68))
So this expression isn't working for you? Does it do anything?
I cant figure out how to do brackets when its on average time late example 0:30 late or 0:31 thru 1:00 hr.1:01 thru 2:00
May be like this:
If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(0, 30), Color1,
If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(1), Color2,
and so on...
ok I can get the first line working but it errors out on the second line
below works but when I add the comma and release the second line error in expression
If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(0, 30), Color1
//If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(1), Color2,
Did you use Color1 or an actual color expression like Blue() or RGB(0,0,255)? You need to use a color in place of Color1 in the above expression
RBG color
This should work, can you share a screenshot of where you are seeing the error?
The first one works but need three colors