How to use a InfluxDB-tag value in a grafana legend?

influxdb grafana
Michael K. picture Michael K. · Feb 22, 2017 · Viewed 17.8k times · Source

I have a InfluxDB dataseries. It stores one information about mulitple machines. I distingsh between these machines with a tag. I can display the information for all three machines at once using a "Group by tag(machine)" clause. the name of the legends is "table.derivative {machine: 1}", "table.derivative {machine: 2}" and so on. How can I change it to "machine 1", "machine 2" and so on?

So far I came across this suggesting to use $groupby (or $g ?), but both are just added a literally.

Answer

Daniel Lee picture Daniel Lee · Feb 22, 2017

In Grafana, you can use alias patterns. There is a description of alias patterns at the bottom of the metrics tab:

enter image description here

In your case, in the Alias By field you would write $tag_machine.

Here is an InfluxDb example on the Grafana demo site that uses the Alias By field:

https://play.grafana.org/d/000000002/influxdb-templated?editPanel=1&orgId=1

Related questions

Is there a way to have a moving average in Grafana?

I didn't find a 'moving average' feature and I'm wondering if there's a workaround. I'm using influxdb as the backend.

Read More
Obtaining a total of two series of data from InfluxDB in Grafana

I am perplexed at this point. I spent a day or three in the deep end of Influx and Grafana, to get some graphs plotted that are crucial to my needs. However, with the last one I need to total …

Read More
Graphing CPU Usage % on Grafana using influxDB data from Telegraf

I have grafana 3.0.4 / influxdb 0.13.0 / telegraf 0.13.1 I am trying to graph overall CPU usage by %. When I create a query using the idle time, I get exactly that (I'm looking for 100 - idle time) (usage) I switched to manual mode and …

Read More