Don't hide the panel if no data in range. Keep the last value before the range?


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:

  1. I turn on the light. Pannel shows the action.

  2. after 5 minutes the pannel disappears, showing no data, although the light is still on.

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.