Difference() by day will not show today created datapoints

[Anaisdg]

Hello @gjemp,
Have you tried using the today() funciton?

today() function | Flux Documentation

You might need to use the timeShift() function

timeShift() function | Flux Documentation

This thread might also be useful to you:

Month aggregateWindow doesn't work with negative offset

Hi, we have an issue that aggregateWindow for month doesn’t work correctly with negative offset. For zero offset it works fine, and for the following query ` from(bucket: “my_bucket”) |> range(start: 2021-01-24T14:10:31+02:00, stop: 2021-12-24T14:10:31+02:00) |> filter(fn: (r) => r._measurement == “my_measurement”) |> filter(fn: (r) => r.machine == “123”) |> filter(fn: (r) => r._field == “span”) |> filter(fn: (r) => r.state == “working”) |> aggregateWindow(every: 1mo, offset: 0s, fn: sum, c…