In Grafana, 'String' automatically converted to 'Int'

Grafana
,
1

Hello,
First Thank you for your Answer, and forgive me that I can`t do English well

I`m trying to show my IoT-Box information in Grafama.

But String value(macID) is converted automatically to Int type.
One of mac address is ‘20579e380462’. But in table, It is converted to ‘∞’.
I think, becuse of ‘e’, Grafana recognize it is ‘int’ type value.

So I try to reconvert to string but I don`t know how.
Please help me.

my query is in below.
Thank you.

from(bucket: “telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “info”)
|> filter(fn: (r) => r[“_field”] == “wifistr”)
|> keep(columns: [“_time”, “host”, “eqpid”, “ip”, “_value”, “chid”])
|> group(columns: [“host”, “eqpid”, “ip”])
|> map(fn: (r) => ({_ip: r[“ip”], _eqpid: r[“eqpid”], _chid: r[“chid”], _macID: r[“host”], _value: r[“wifistr”]}))
|> unique(column: “_macID”)

2

Hello @yeongin,
Welcome!
Thanks for writing in English :slight_smile:
You can do the following to convert to string:

from(bucket: “telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “info”)
|> filter(fn: (r) => r[“_field”] == “wifistr”)
|> keep(columns: [“_time”, “host”, “eqpid”, “ip”, “_value”, “chid”])
|> group(columns: [“host”, “eqpid”, “ip”])
|> map(fn: (r) => ({_ip: string(v: r.ip) , _eqpid: string(v: r.eqpid), _chid: string(v: r.chid),  _macID: string(v: r.host) , _value: string(v: r.wifistr) }))

Let me know if that helps
Or you can do