请更正Grafa的通量查询，以计算和显示两列AAA＆＃x2b; bbb的结果

Question

//我正在使用序列在fluxdb中插入fluxdb：

'sever1,submeas=XXX AAA=899265',
'sever1,submeas=XXX BBB=2281289',
'sever2,submeas=XXX BBB=2672',
'sever2,submeas=XXX AAA=0',
'sever3,submeas=XXX AAA=947439',
'sever3,submeas=XXX BBB=897226'
    

// flux查询

from(bucket: "llc")
    |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
    |> filter(fn: (r) => r["_measurement"] == "server1" or r["_measurement"] == "server2" or r["_measurement"] == "server3")
    |> filter(fn: (r) => r["_field"] == "AAA" or r["_field"] == "BBB")
    |> filter(fn: (r) => r["submeas"] == "XXX")
    |> aggregateWindow(every: v.windowPeriod, fn: mean,   createEmpty: false)
    |> yield(name: "mean")
    

//我应该为AAA+BBB做什么？我尝试过添加了最后一个条件，但没有帮助。

        |> map(fn: (r) => ({r with _value: r.AAA + r.BBB}))

Answer 1

我在文档中找到了解决方案的 https://docs.influxdata.com/

from(bucket: "llc")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "server1" or r["_measurement"] == "server2" or r["_measurement"] == "server3")
  |> filter(fn: (r) => r["_field"] == "AAA" or r["_field"] == "BBB")
  |> filter(fn: (r) => r["submeas"] == "XXX")
  |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")
  |> map(fn: (r) => ({r with _value: (r.AAA + r.BBB)}))