Hi,
Looks like |> aggregateWindow(every: 1mo, fn: last, createEmpty: false) has got a bug
While trying this query
import "timezone"
import "date"
option location = timezone.fixed(offset: 330m)
from(bucket: "history")
|> range(start: date.truncate(t: -5mo, unit: 1mo))
|> filter(fn: (r) => r.org == "4" and r["_measurement"] =~ /wmLoRa/ and r["_field"] == "counter")
|> sort(columns: ["_time"])
|> aggregateWindow(every: 1mo, fn: last, createEmpty: false)
The window is picking data between 30th of every month instead of 31
