Grafana Influxdb Flux Query

Grafana Dashboards
,
1

Hello All , am using influxdb query for displaying on grafana dashboard for cisco IOS XE devices. As variable am able to create list of Source devices and their interfaces , but not able to show respecitive MAC address

Secondly am trying to show BGP neighborship state in table format , it is working on Influxdb but not grafana query. Both queries and snapshot are mentioned below, please guide me where am doing some mistakes.

image
image1818×685 82.1 KB

GITQUERY
GITQUERY1273×676 68.5 KB

Regards

2

In Grafana you have 2 transformations configured - what changes if you disable them?

3

No change after removing transformation

4

Hi @uniquewaheed

Two things that I see…

  1. Try inserting a group() function before or after the unique() function and see how that affects things. I see you have 3 streams of tables in InfluxDB (0, 1 and 2) and usually just 1 is best for Grafana
  2. Try experimenting with the unique() function’s Column parameter. The unique() function can accept as a parameter any Column to search for unique values. The default is _value.