${__field.name} just shows value as label

Grafana InfluxDB
, ,
1

Hello,
I’m trying to display custom field name (${__field.name}) in my grafana but for some reason is just showing “Value”

here what I’m getting

image
image1146×307 13.9 KB

here the original before add ${__field.name}, I want to get just supplies description without this part {prtMarkerSuppliesDescription=

{prtMarkerSuppliesDescription=“Kit mantenimient”}
{prtMarkerSuppliesDescription=“T�ner negro”}
{prtMarkerSuppliesDescription=“Unidad imagen”}

image
image1153×307 17.4 KB

here my query.

image
image849×229 23.1 KB

any advice on how to custom and field name here

2

What is your datasource?

3

it’s influx QL

image
image1153×366 49.1 KB

4

Could you please provide sample data as inline csv por favor? for example.

name,time,host,topic,value
mqtt_consumer_float,1662507929695650760,vps-362a4be9,GPS/Latitude,43.5785
mqtt_consumer_float,1662507940992628730,vps-362a4be9,GPS/Longitude,1.44712
mqtt_consumer_float,1662508438504964767,vps-362a4be9,GPS/Latitude,43.5784
mqtt_consumer_float,1662508449814560959,vps-362a4be9,GPS/Longitude,1.44725
mqtt_consumer_float,1662508934276570198,vps-362a4be9,GPS/Latitude,43.5786
5

this is what I’m getting exporting the data.

“Time”,“Metric”,“Value”
2022-09-08 18:00:00.000,“{agent_host=”“10.89.13.181"”, prtMarkerSuppliesDescription=““Kit mantenimient””}“,0
2022-09-08 18:00:00.000,”{agent_host=““10.89.13.181"”, prtMarkerSuppliesDescription=”“T ner negro”“}”,9
2022-09-08 18:00:00.000,“{agent_host=”“10.89.13.181"”, prtMarkerSuppliesDescription=““Unidad imagen””}",2

6

I forgot mencioned… value is the result from 2 queries.

image
image493×549 41.3 KB

and I using this transformation

image

7

this looks like export from grafan? can you provide export from influx?I see a few fields missing.
This is so that we have your data in our influxdb

8

here you are from influx

table _start _stop _time _value _field _measurement agent_host host prtMarkerSuppliesDescription
0 2022-09-09T19:09:37.490418072Z 2022-09-09T20:09:37.490418072Z 2022-09-09T19:10:10Z 0 prtMarkerSuppliesMaxCapacity printerstack 10.89.13.181 vm2-tig-8901 Kit mantenimient
1 2022-09-09T19:09:37.490418072Z 2022-09-09T20:09:37.490418072Z 2022-09-09T19:10:10Z 9 prtMarkerSuppliesMaxCapacity printerstack 10.89.13.181 vm2-tig-8901 T�ner negro
2 2022-09-09T19:09:37.490418072Z 2022-09-09T20:09:37.490418072Z 2022-09-09T19:10:10Z 2 prtMarkerSuppliesMaxCapacity printerstack 10.89.13.181 vm2-tig-8901 Unidad imagen
1 Like
9

csv view

result,table,_start,_stop,_time,_value,_field,_measurement,agent_host,host,prtMarkerSuppliesDescription
,0,2022-09-09T19:09:37.490418072Z,2022-09-09T20:09:37.490418072Z,2022-09-09T19:10:10Z,0,prtMarkerSuppliesMaxCapacity,printerstack,10.89.13.181,vm2-tig-8901,Kit mantenimient
,1,2022-09-09T19:09:37.490418072Z,2022-09-09T20:09:37.490418072Z,2022-09-09T19:10:10Z,9,prtMarkerSuppliesMaxCapacity,printerstack,10.89.13.181,vm2-tig-8901,T ner negro
,2,2022-09-09T19:09:37.490418072Z,2022-09-09T20:09:37.490418072Z,2022-09-09T19:10:10Z,2,prtMarkerSuppliesMaxCapacity,printerstack,10.89.13.181,vm2-tig-8901,Unidad imagen

1 Like
10

I would go with using flux instead of influxql

image
image1096×632 30.4 KB

Let me try it using influxql

11

Sure no problem, but looks good

12

can you run this in your influxbd:8086?
replace guelo to proper bucket name.

from(bucket: "guelo") 
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "printerstack")
  |> filter(fn: (r) => r["_field"] == "agent_host" or r["_field"] == "host" or r["_field"] == "prtMarkerSuppliesDescription" or r["_field"] == "prtMarkerSuppliesMaxCapacity")