I’ve got a dashboard where im plotting temperatures and fan speed. The temperatures change pretty often while the fan speeds can stay constand for an entire day.
The problem is I want to have a time range of say 3h, but then I get “No data” in the graph of fan speeds.
How can I extend the last value of fan speeds from outside the time range?
SELECT last("value") FROM "mqtt_consumer" WHERE ("topic" = '2._etg/Ventilasjon/Viftehastighet_tilluft') AND $timeFilter GROUP BY time(10s) fill(previous)