Flux: Simple way to query multiple measurements & return ONE table

Fluxlang
2

Hi, get rid of the _measurement column and sort by time.
You will end up with a single sorted table:

from(bucket: "iobroker/global")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) =>
    ( r._measurement = "old-measurement" or
      r._measurement == "new-measurement" ) and
    r._field == "value"
  )
 |> drop(columns: ["_measurement"])
 |> sort(columns: ["_time"], desc: false)

Kind regards,
Domenico

1 Like