I have a working setup visualising various weather sensors and I now want to display the hourly rain level. The measured millimetres are passed to InfluxDB from my Python code every 5 minutes and I can display it as a continuous line graph but I want InfluxDB to also bar graph the rainfall of every hour, on the hour.
This is my first attempt, does it look like it will do the job? Thanks.
SELECT cumulative_sum(mean("Rain mm")) FROM "Rain" WHERE ("location" = 'Home') AND $timeFilter GROUP BY time(1h) fill(none)