I'm using the Gauge widget to display the state of an Alert Sensor.
The Alert Sensor is updated by a homebrew script, which takes data from a dynamic energy provider (Tibber) and shows a relative indication on the actual electricity price. e.g. 'error, very cheap/cheap, normal, expensive, very expensive'.
Objective: the Gauge widget to show the Alert Sensor state given its 'Alert level' (0 - 4) and 'Alert text'. The Alert Text contains the Alert Level and the actual electricity price. The arc color to represent the level (green / yellow / orange/ red etc.).
Hence, I created a Gauge widget and linked it to the Alert Sensor. The Gauge widget shows the Alert Text as expected. yet the arc is always greenish.
However, I do not seem to be able to set the widget's Value Range colors such that it corresponds with the Alert.
I tried various widget setting but obviously not the right one.
While trying, I noticed that the Gauge widget seems to parse 'Value Text' and take the starting 'number' in the text string as value. Purely by coincidence I was repeating the Alert Level as text in the Alert Text). The Gauge widget does not seem to interpret the 'Alert Level' number.
How to set the Value Range color ranges for this case?
Picture shows example of the current state