Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm wondering if there is a way to set the color of the LED gagues based on a value or if the color of these gauges is always constant.
We would like the LED gague to show the value of the measure and then have the color of the LED be based on the goaIs set for that measure. Is this something in the "Reference Line" settings for the gauge?
Thanks!
Perfect!! Thank you!!
The second color is used for a gradient and is always greyed out if Solid Color is selected.
I don't believe gradients are allowed in LED gauges.
Just realized what you are trying to do...
the formula in the calculated color should be something like...
if (count(value)>50,blue(),red())
You can use the color functions or rgb() to set the color.
Could it work to use the Visual Cues tab to identify the Upper and Lower colors and just show straight text?
I've tried entering the same IF statement in the Upper and Lower areas, but it only seems to be recognizing the last value. I have Location as the dimension in my table.
IF(Location=21. .76, .69)
Entering this makes each line go off of the .69 value. Even in the row corresponding to Location 23, where the value is .74 it should be caught in the lower bound. Thoughts?