When I query with Flux in Grafana with InfluxDB, all columns except the time column are merged into a single column name

Grafana
1

I am using Grafana 10 and influxdb 2.7.

I am using flux to get data.

from(bucket: "VFBckStrg")
  |> range(start: -5d)
  |> filter(fn: (r) => r["_measurement"] == "VMwareRawData6")

I should show all columns in a table in grafana. But it shows 2 columns. One is time column. Second column name is combination of all column names. But it should show all columns seperately in the table dashboard.

As you can see from image Start_Time, Client_Name and Policy_Name are shown i 1 column name. But they shoul be seperated colums. The values you see are Start_time values. Only Client_Name and Policy_Name is tag. Others are field.

grafana1
grafana11568×408 21.8 KB

How can i display all columns seperately.

I tried to filter column names with keep. But not displaying columns seperately.

2

Hi @ivbtar

Normally one uses the Flux query to drill down further and display the fields & tags you want, aggregate the data, perform additional conversions or functions, etc. But given your query, I think the Labels to fields transformation should work.

image

1 Like
3

Thanks a lot grant.
You saved the day!!!