Influxv2 Heatmap Labels

[rmorgan466]

Using Grafana 9.2.4. Backend is Influxv2. I have a heatmap. The Y axis shows
used_percent {host=“foo”,name=“mem”}

Is there a way to just show “foo”. Simalr to $__field.display.X? I can’t seem to find it.

[ldrascic]

Hi @rmorgan466,
Can you try with Rename by regex transformation like described on link:

Can you extract a word from within a tag to automatically label the legend?

Hi @ppxtb, In Transform tab (near Query) you can choose Rename by regex and for Match enter: .*\(([^\)]+).* and leave Replace as $1. [Grafana regex] Regex breakdown: .* - means any symbol 0 or more times (basically means match anything) \( - specifies that after anything there must be a literal symbol ( ( - starts matching group [^)]+ - means match anything until you find ) symbol ) - closes matching group .* - matches anything till the end Replace breakdown $1 - means return wha…

 

Regex for your case:

.*host="([^"]*)".*

Breakdown:
.* - matches anything
host=" - after that it looks for string host="
([^"]*) - this is value that you will capture in first group (marked with $1). It captures everything till first double quote "
.* - matches anything after that
 

This will print only foo in this case.

 

Best regards,
ldrascic