My home automation system sends the values of the sensors to influxdb every 10 minutes. Now I want to show the maximum value of 1 day in Grafana, but also the sum of the maximum values of the days within 1 week, 1 month and 1 year.
This is what I’ve got so far but I can’t get any further. Someone who has a solution?
SELECT max("EnergyToday") FROM "inverter" WHERE $timeFilter GROUP BY time(1d) fill(null) TZ('Europe/Amsterdam')