Puzzled time with aggregateWindow() function

InfluxDB 2
, ,
1

a topic linked to github
when query code is:

from(bucket: "CS301") 
  |> range(start: 2024-05-29T16:01:00.000Z, stop: 2024-05-29T16:30:00.000Z) 
  |> filter(fn: (r) => r["_measurement"] == "CS105.R-A5100") 
  |> filter(fn: (r) => r["_field"] == "pi01") 
  |> aggregateWindow(every: 7m, fn: last, createEmpty: false, timeSrc: "_time",  
//   offset: 1m 
) 
  |> yield(name: "last")

1.data retrieved as bellow when every is setted to 7m

7m
7m1012×643 126 KB

  1. data retrieved as bellow when every is setted to 8m
    8m
    8m1011×642 117 KB

when query code is:

from(bucket: "CS301")
    |> range(start: 2024-05-29T16:01:00.000Z, stop: 2024-05-29T16:30:00.000Z)
    |> filter(fn: (r) => r["_measurement"] == "CS105.R-A5100")
    |> filter(fn: (r) => r["_field"] == "pi01")
    |> window(every: 7m, createEmpty: true)
    |> unique(column: "_start")

data retrieved as below:

union
union1269×677 142 KB

2

Hello @Leo,
Thanks for sharing this here as well as the issue. There’s good activity on the issue so I want to point ppl to just go there if they’re encountering similar problems.