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

Since google pointed me here… This post: Average per hour - #14 by MarioG shows how to do this. One thing i would change is to use integral instead of mean in the aggregate window

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

Fluxlang

digitaldex February 26, 2020, 1:16pm 2

I posted a possible solution here

Topic		Replies	Views
How to create time of day averages Fluxlang	3	808	March 21, 2023
Average per hour influxdb	12	20594	September 10, 2025
Question on Flux InfluxDB 2 flux	1	396	February 10, 2023
Group by every hour of the day Fluxlang	4	7221	March 14, 2022
Average hourly value from time series data InfluxDB 1	1	815	November 7, 2021

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

Related topics