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. …

Is it possible to get hourly averages over a period of time with Flux?

digitaldex February 26, 2020, 1:16pm 2

I posted a possible solution here

Topic		Replies	Views
Average hourly value from time series data InfluxDB 1	1	740	November 7, 2021
Question on Flux InfluxDB 2 flux	1	334	February 10, 2023
Calculate the total power usage Dashboards	4	2223	February 6, 2024
Group by every hour of the day Fluxlang	4	5321	March 14, 2022
Aggregation per hour Fluxlang influxql	4	4071	November 12, 2021