New Calculated Column not Displaying

InfluxDB 2
1

Hi
I have 2 fields (load_power and eddi_diversion from two different measurements. I would like to create a 3rd calculated field from these two fields and display all three in Influx/Grafana. However I cant get it to display all 3 values. My flux is below…any assistance appreciated.

from(bucket: "giv_real_bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "SD1334078" or r["_measurement"] == "inverterStats")
  |> filter(fn: (r) => r["_field"] == "load_power" or r["_field"] == "eddi_diversion")
  |> group()
  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
  |> map(
        fn: (r) => ({
            r with _value: float(v: r.load_power - r.eddi_diversion)
        })
    )
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
2

Hello @ffarrell,
Welcome! You’ll have to use multiple yield statements like:

data = from(bucket: "giv_real_bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "SD1334078" or r["_measurement"] == "inverterStats")
  |> filter(fn: (r) => r["_field"] == "load_power" or r["_field"] == "eddi_diversion")

data |> yield(name: "raw data")

data
  |> group()
  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
  |> map(
        fn: (r) => ({
            r with _value: float(v: r.load_power - r.eddi_diversion)
        })
    )
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "aggregated")
1 Like
3

Many thanks for your prompt reply. My query isn’t yet working as I want as the timestamps are different in each of the two measurements. If there any way to work around this?

Thanks again.