Hi all, apologies for what might be a rather basic question.
I am pushing telemetry from a Cisco device to Influx / Grafana to setup a dashboard that tells me when Access Points (Wifi AP’s) are online or offline.
Ive found the telemetry subscription I want which populates the “_field” group string named “is_joined”.
What im interesting in is the “no group bolean” next to the group string called “_value”:
The way Grafana parses the result from InfluxDB is that if a _value column is found, it is assumed to be a time-series. The quick workaround is to add the following rename() function:
|> rename(columns: {_value: "something"})
Can you try that and report back? You may have to experiment where in your Flux query to place the above statement.
So I’ve added the rename function to my flux query per your suggestion (tried a few difference places) and it has indeed renamed the “_value” to the value I specified “_ap_joined”
Can you add a filter statement like this just after the rename line and see if that displays anything in Grafana? |> filter(fn: (r) => r["_ap_joined"] == "false")
I managed to get this working using a stat visualisation.
Under Value options, setting calculation to “last”, fields to the “is_joined” value listed in the drop down and then creating two value mappings to rename true to “up” & false to “down”.
