Feature: write all states, changed or not, regularly about ltss HOT 2 CLOSED

Depending on your situation, you could do something similar as i did. In my specific case, "no data" respresents the functional value of 0.

If this does not work for you, i think it is better to create an issue for Grafana to ask for this feature. In the end, this is a limitation of Grafana. Repeating data points would be a work-around and not tackling the root cause.

SELECT a.time,
a.metric,
SUM(a.value) AS value
FROM
(
SELECT
  $__timeGroupAlias("time",1m),
  entity_id AS metric,
  max(cast(state as numeric)) as value
FROM ltss
WHERE
  $__timeFilter("time") AND
  entity_id in ('sensor.gas_consumption_5m')
GROUP BY 1,2, $__timeGroup("time",'1m', 0)
UNION ALL
SELECT
  date_trunc('minute',((now())::timestamp ))as "time",
  'sensor.gas_consumption_5m' AS metric,
  0 as value
ORDER BY 1,2
) a
GROUP BY 1,2

from ltss.

As already pointed out by @pimw1, this is really a limitation of Grafana and should not be handled by this kind of work around.

from ltss.