Hi,
I am trying to create a gauge chart which is similar to a traffic light system. In my expression on the gauge chart I have the following:
=Interval((RangeMin(frac(Closedate), MakeTime(18))
- RangeMax(frac(Logdate), MakeTime(8)))
+ (NetWorkDays(Logdate, Closedate-1) * MakeTime(10)) // Only 10 hours per whole day)
The above expression, basically takes the closedate away from the logdate and leave me with a time in hh:mm:ss that is calculated between 08:00-18:00 on weekdays, which we call the Duration.
In the Gauge chart however, I want to set this 'traffic light system' to ensure that when a certain time is reached, the red LED is selected, when it isn't reached the Green LED shows:
E.G. If the Duration is say 01:35:00 (in hh:mm:ss), I want to ensure that the Red LED only comes on when 02:00:00 is reached.
To add on top of that, I have a field called Priority, and in that field there will only ever be 5 values. They are: Priority 1, Priority 2, Priority 3, Priority 4 and Priority 5. What I also want to include is that depending on the Priority, the Red LED is activated. Therefore if the issue is a Priority 1, I want the RED LED to be activated at 01:00:00, if it is a Priority 2, to be activated at 04:00:00 etc etc.
Is this possible>
