I’m using InfluxDB and Grafana to visualize some data recorded in Home Assistant, particularly temperatures.
I would like to group data into average day and night temperatures (say, average all data from 0700-1900 and 1900-0700).
Can any kind user give a layman a hint, how to do that? Googling was of no help, only found out, how to group by time slots of the same day by fiddling around with
GROUP BY in
SELECT mean("value") FROM "°C" WHERE ("entity_id" = 'thermostat_hc1_current_room_temperature') AND $timeFilter GROUP BY time($__interval) fill(previous)