Bonjour ,
I started to collecting iot data since may 2021.
Now i try to downsampled datas to anoher bucket.
i have this task who it working well: ( 1hour mean )
option task = {name: “test_1h_means”, every: 1h}
from(bucket: “espeasy”)
|> range(start: 2021-05-11T12:00:00Z, stop: -1h)
|> filter(fn: (r) =>
(r[“topic”] == “T_maison_3/sensors/Temperature”))
|> filter(fn: (r) =>
(r["_field"] == “value”))
|> aggregateWindow(every: 1h, fn: mean)
|> to(bucket: “downsampling-test”, org: “oNe”)
|> set(key: “temp_test”, value: “testmaison_moyenne”)
|> to(bucket: “downsampling-test”, org: “oNe”, tagColumns: [“test_moyenne”])
Firt time running the task, bucket downsampling-test is filling well.
I imagine in few months, this task had to calculate the mean for a large amount of data as it takes beginning starting date 2021-05-11.
Is that the best practice ?
Have a ‘one shot task’ to retrieve data from the beginning and another one with one day before range for just collecting the last day data ?
Or there is another way ?
Thanks
