aggregateWindow 1d is getting data from the day before

Hi,

I have a strange behaviour.
I inserted daily data with the timestamp like this : 2023-04-12T00:00:000Z
When I try to aggregate data by day, for each day, I am getting the value of the day before.

Can you explain the behaviour ? I expect to get exactly the same result …

Thank you

Hi @Remi_GRZ and welcome to the InfluxDB forum.

Can you try the timeSrc option in your aggregateWindow function and see if that helps, like this?

|> aggregateWindow(every: 1d, fn: mean, createEmpty: false, timeSrc: "_start")

More explanation here

That solved m’y issue.

Thank you for your help !

Great. Please mark the above as Solution so others can find it in the future.