I would like to group values not common time value.

For example,
From Monday to Sunday, I have data (averaged by inflow) hour by hour.
I would like to group everything into “a single” day and average the values hour by hour.
(Monday at 9:00 = 10° and Wednesday at 9:00 = 15° then the average for 9:00 is 12.5°)

Or ,
From January to December, I have hour by hour values. I would like to make a “typical day” representative of all these days.

I use the Flux language but if you would like to give me an equivalent in QL I am interested given the depreciation.

Today, I have no idea how this was achieved. I hope I was clear on my explanations and hope to get some help.
Thank you.

If you’re using InfluxDB Cloud Serverless, InfluxDB Cloud Dedicated, or InfluxDB Clustered you could use SQL. Otherwise, you’ll have to wait until the open-source version of v3 is available.

I want the _values for each day of the period to be grouped together as a sum per hour. Then, the script should perform the daily average for each hour.