[URGENT] Aggregate within window gives unexpected data points

[airsence]

FYI: I’ve reviewed other community topics and tried to implement their suggested solutions, (e.g., using timeShift), most notably this topic:

Unexpected timestamp when using aggregated window per day

Hello, I am quite new to using InfluxDB (and also use Grafana in addition), but hereit is about pure InfluxDB behaviour. I am trying to query some data using Flux in the Data Explorer. I am working with an aggregated window and try to get the last value of a day. When setting the aggreation to 5s (seems to be the minimum), I have the individual values around the day change. If I now change the aggregation to 24h / 1d, I do get this: [image] The values shown seem correct for me, but I woul…