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 …
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.