InfluxDB 2 - get specific mean values

InfluxDB 2
,
1

Hello.
I need some help for forming query to find the average value per minute for 20 days.
For example, I need mean value for 00:00(from 2022-03-01 to 2022-03-20), 00:01(from 2022-03-01 to 2022-03-20), etc…
Can somebody help me with this query?
A lot of thx

2

Hello @v_lisovoi,
Welcome!
Your query would look like:

from(bucket: "noaa")
  |> range(start: 2022-03-01, stop: 2022-03-20)
  |> filter(fn: (r) => r["_measurement"] == "average_temperature")
  |> filter(fn: (r) => r["_field"] == "degrees")
  |> filter(fn: (r) => r["location"] == "coyote_creek")
  |> aggregateWindow(every: 1m, fn: mean, createEmpty: false)
  |> yield(name: "mean")
3

@v_lisovoi do you come from a sql or InfluxQL background?
These might be helpful resources