Create check based on value rather than threshold

I’d like to create a check/alert based on the last value obtained from and snmp query of a Dell RAID controller. The possible values are:
0:Unknown
1:Ready
2:Failed
3:Online
4:Offline
6:Degraded

I’d also like to update the color and text displayed in the single stat dashboard item.

Any way to do this?

Thanks!

Hello. @edub05 ,
I believe the following blogs would be useful to you:

That being said, I recommend mapping your values to a numerical values for a task.

|> map(fn: (r) => ({
r with
_level:
if r._value == "0:Unknown" then 0
if r._value == "1:Ready" then 1
...
else 6
}))

And then you can set alerts for each numeric value.

Yes you can display the value as a single stat and and colorized threshold for visualization.