Show tags as a column

I want to create a Table including ap_name, radio band, channel, EIRP, Noise Floor.

I tried this Flux query:

from(bucket: "data")
 |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
 |> filter(fn: (r) => r["_measurement"] == "AP")
 |> filter(fn: (r) => r["ap_name"] == "D1_xxx_xxxx")
 |> group(columns: ["ap_name", "radio_band", "channel", "eirp_10x", "noise_floor"], mode: "except")
 |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
 |> yield(name: "last")

However, it only shows the ap_name, radio_band, and channel columns.
image

FYI, ap_name, radio_band, and channel are field keys, while eirp_10x and noise_floor are tag keys.

How can I solve this so I can display the tag keys as table columns?

Hello @alifyazhafira29,

First of all, you can’t select tag with InfluxDB : in InfluxDB, tag keys are metadata associated with measurements, while field keys contain the actual data values. I think you should ask your question in the Influx community…

Regards

1 Like

This might also help

And

1 Like