Total daily consumption from TimescaleDB LTSS

SELECT
  time_bucket_gapfill('1 minutes', "time") AS "time",
  entity_id,
  MAX(state::float) as "value"
FROM ltss
WHERE
  $__timeFilter("time")
  AND entity_id like '%consumptio%_daily%'
  AND state NOT IN ('unknown', 'unavailable')
GROUP BY time_bucket_gapfill('1 minutes', "time"), 2
ORDER BY 1,2