I have a dashboard with the panel stat, this panel read data a mysql table,
I have 2 boolean states, 0 or 1 I want to play with these values make a state label with color depending on what is being read from the table, 0 would be yellow, 1 would be green and finally if not no more are written rows in the table that interprets that there is no value and turns red.
my problem is that when values or rows are not being inserted in the table it always shows me the last value, either 0 or 1, so I can never show the label in red, I have tried to configure show last value and last value not null and it doesn’t work.
This is my configuration panel:
Right now it’s been more than an hour since I have records in the table
and as you can see the panel is green because the last value was 1 and my need is that when no data is recorded it turns red.
my query to mysql table is this: