Month aggregateWindow doesn't work with negative offset

[Anaisdg]

Hello @ellibas,
The only other thing I can think of that might be related to what you’re asking is:

How does it show data on day of week?

Hello @mm0001, I don’t exactly know what you mean by pick up data on every Friday. Here’s how I filtered for data that’s only written on a Friday and then performed an aggregate window. import "date" from(bucket: "noaa") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "average_temperature") |> filter(fn: (r) => r["_field"] == "degrees") |> filter(fn: (r) => r["location"] == "santa_monica") |> map(fn: (r) => ({ r with weekday: date.w…

I encourage you to take a look at the date package:

date package | Flux Documentation

Otherwise I look forward to you sharing your input data, query, and expected output.