Setting threshold from maximum to minimum

Hello,

Is it possible to set thresholds from Maximum to Minimum under singlestat panel.

I am collecting health score % metrics(ex: 85%…), and expect color change if metrics goes down below 30% till 0%.

Hope i make sense. :slight_smile:

Regards,
Rohit

This sounds simple unless I am misunderstanding :slight_smile:

Just invert the threshold colors and set the threshold to 30. So a value is green if it is over 30 but would be red if it went under 30:

Thanks for the help…Daniellee :slight_smile:

1 Like

How about if we want to show a threshold of a value Being either positive or negative ?

ie -300 … 0 is a red part in the gauge
0 … 300 is a green part in the guage

That should work. Singlestat can handle negative values in thresholds.

So how would you input that in the threshold area?

-300,300
or
some combination of -300,0,300

So basically if it is less than 0 it should be red and if it is greater than 0 it should be green. Thresholds are usually defined with two values giving you three states (red, yellow, green). In your case, you only want two states so this should work:

image

Great thank you.

So in the context of a Boolean
My DB reads 1 (True) or 0 (False)

Would I set up my threshold the same way = 0,1 (invert)

When comparing a range, the logic is > lower threshold and <= higher threshold so in your case, you could use a decimal to get >= for the lower threshold.

Like this: 0.1,1 (invert)

Hi daniellee ! Can we implement a threshold based on another column value ?


To be more clear, I want the color to turn red if it value is lower than the other value on the right.
Thanks