I stored instantaneous power usage of my home in an influxdb time series and I would like to get the hourly average over a chosen period of time.
In other words input data ranging a month, and output data a table with 24 rows, one value per row.
Basically I want my average daily power usage curve.
Someone else asked the same almost two years ago: Average per hour
It was not possible.
Can I do it with Flux now, which was not available back then?
Which syntax should I use? I have zero experience with Flux.