Compare to previous column string value

InfluxDB 2
6

Hello @R0bR,
How are you writing empty strings? Wouldn’t it be easier to not write that value?
Anywho this should work:


import "experimental/json"
null=json.parse(data: bytes(v: "null")) 

from(bucket: "test")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "test")
  |> filter(fn: (r) => r["_field"] == "foo")
  |> filter(fn: (r) => r["test"] == "one")
  
    |> map(fn: (r) => ({
    r with
    _value:
      if r._value == "" then null
      else  r._value 
    })
  )
  |> fill(usePrevious: true)
1 Like