#Influx + Grafana dashboard problem

1 messages · Page 1 of 1 (latest)

next vector
#

Hey guys I have a grafana + influxdb dashboard (see pic here https://d.pr/i/AAwX05). As you can see the bottom panels are not working anymore, they were grouping the energy consumption into days and I'm not able to figure out how to make the call to make it work again

Current call is

SELECT sum("mean")/3600 FROM (
  SELECT mean("value") FROM "W" WHERE entity_id='shelly_usage_watts' AND $timeFilter GROUP BY time(1s) fill(previous)
) WHERE $timeFilter GROUP BY time(24h) fill(null)
#

Is anyone able to see what's wrong? I even tried with ChatGPT but I can't get it to work. I get consumption info from Shelly every second