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
Flux Query: Calculate average of measurement in current month Fluxlang time , query , flux	2	1239	December 15, 2022
Average hourly value from time series data InfluxDB 1	1	794	November 7, 2021
Question on Flux InfluxDB 2 flux	1	385	February 10, 2023
Calculate the total power usage Dashboards	4	2599	February 6, 2024
Group by every hour of the day Fluxlang	4	6465	March 14, 2022