Hi.
I’m having a problem that panels hide if no data is presented in the selected range. I would like to keep the last value (even if out of range) and assume it as a current state.
For example:
-
I turn on the light. Pannel shows the action.
-
after 5 minutes the pannel disappears, showing no data, although the light is still on.
Query:
SELECT mean(“value”) FROM “mcsMQTT” WHERE (“device” = ‘1st_Kitchen_39-Switch’) AND $timeFilter GROUP BY time($__interval) fill(previous)
Any ideas on what to do to keep the last value before the selected range?
Thank you.
Br,
KD