I am trying to upgrade influxDB database from 1.8 to 2.2. All of query methods and result(column names) are different on FLUX.
My query on influxDB 1.8 is
select sum(value) from device_frmpayload_data_Wm1 where ("device_name" = 'k5') AND time > now() - 7d group by time(1d) order by desc limit 7On version 1.8 I can able to change field name as formatted time with ${__cell_0:date:DD.MM}
How can I get same results on influxDB 2.2 ?
from(bucket: "kSensors")
|> range(start: -7d)
|> filter(fn: (r) => r["device_name"] == "k5")
|> filter(fn: (r) => r["_measurement"] == "device_frmpayload_data_Wm1")
|> filter(fn: (r) => r["application_name"] == "SensorsApp")
|> aggregateWindow(every: 1d, fn: sum, createEmpty: false)
|> window(every: 1d)
|> yield(name: "sum")