State config MySql

Grafana Configuration
,
1

Hi,

I have a MySql table that have a field door, in this field I indicate if it is open or closed.

Can I use singlestat to display the statue?

And what would be the query be?

If it is is open I want it red with the text “open” and if it is closed I want it to be green with text “closed”

image

Thanks for your help

2

@johans you can achieve an effect like that using value mappings:

as far as the query, have you already configured the mysql datasource plugin in Grafana?

3

Thank you

image