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

Question

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.

Daniel Lee · Accepted Answer · 2020-12-21T09:58:38.343

43

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

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

edited Dec 21 '20 at 09:58

answered Feb 22 '17 at 21:53

Daniel Lee

7,709
2
48
57

is it possible to use the Field name ? – Wonay Aug 13 '18 at 16:25
@Wonay did you try $col? You could it use with the alias function (or using AS if writing a raw query: SELECT mean("myfield") AS "myfield") to get what you want. – Daniel Lee Aug 15 '18 at 19:49
the link is not valid anymore – littleAlien Dec 20 '20 at 10:07
@user_x try https://play.grafana.org/d/000000002/influxdb-templated?orgId=1 instead – Daniel Lee Dec 21 '20 at 09:57

score 4 · Answer 2 · answered Mar 29 '22 at 07:37

4

If you are using InfluxDB with Flux query language, use the following in the Display Name

${__field.labels}
${__field.labels.<tag_name>}

or in some cases this might work

${__field.labels.name}

answered Mar 29 '22 at 07:37

sai anudeep

1,135
13
26

This helped me big time :) thanks! You can also chain the fields, so Display Name can contains something like: `${__field.labels.host}: ${__field.labels.path} (${__field.labels.device})` - example for disk usage – darkless Dec 28 '22 at 19:20

score 0 · Answer 3 · answered Jun 02 '20 at 12:23

0

For me $_tag_TAGNAME worked ... none of the above worked for me ( even though I saw it in the help section of my instance of Grafana ...)

answered Jun 02 '20 at 12:23

Ricky Levi

7,298
1
57
65

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

3 Answers3