I’m getting very strange results with the colour change for the gauge.

For the operation I created in the lab,

• The query returns 1292.
• I’ve set the gauge maximum to 1500.
• Three colours – green, yellow and red.
• Two thresholds 1290 and 1300.

So the gauge should be yellow right? But it isn’t, it’s green.

In order to make the gauge show yellow, I have to set the first threshold to 86. If I set the threshold to 87 or above, the gauge still shows green. Now that’s curious, because 1292 * 100 / 1500 = 86.1, so it looks like the thresholds need to be configured as a percentage of the gauge range, and not an absolute value.

Except…

If I look at the TRN_VIZ_Gauge operation that was already present on the VM (so not the one I created), it behaves as expected. The thresholds are 1290 and 1300, and it is correctly displayed in yellow when the query returns 1292.

I cannot see any difference in the configuration between the original operation and the one I created, so what could explain the different behaviour? Or what configuration option have I missed?

I hope this makes sense, see the screenshots if that helps.