Worldmap Pivot row naming

Grafana Dashboards
, ,
1

Hi Folks,

i’m playing around with flux data and the amazing geomap panel of grafana. I love it but have a “cosmetic” issue i would like to solve.

I had data in query only with time and float values. The result was a table list with names “Match:1” “Match: 2” etc…
image

Now i have added a string value as a field to my measurement and now the pluging decided to use that as name of the rows:
image

My query is this:

from(bucket: "location")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "geo_measurement")
  |> filter(fn: (r) => r["_field"] == "lon" or r["_field"] == "lat" or r["_field"] == "temperature" or r["_field"] == "src")
  |> filter(fn: (r) => r["location"] == "theRACK")
  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")  
  |> drop(columns: ["_start", "_stop", "_measurement", "type"])

I would like to have just the timestamp as row naming. And i don’t understand why it has been changed from “Match X” to string field & value.

Can anybody enlight me please?

best regards
Dirk