Change the field or series name

[johans]

I have a InfluxDB quarry I run, in the DB I have several different sensors data logged to the same table.

select temperature as “Hive-1” from ec300_msc where dev_eui = ‘xxxxxxxxx0044’

The dev_eui identifies the sensor in the table. I want the label on the graft to reflect a human readable label - Hive-1. But it adds the DB table name in front of it. How do I remove the table name?

Bear in mind I have two quarries running so can not use Stander Options - Display name - Change the field or series name

[mattabrams]

@johans

This should be possible using regex-based value mappings:

How to Rename Values in Grafana Using Regex-Based Value Mapping

@fadjar340 Here are the new Grafana docs for regex-based value-mapping. And here is an example, using your data. I copied your string value, but not exactly [CleanShot 2021-09-28 at 13.01.37@2x] Chose the new Regex option: [CleanShot 2021-09-28 at 13.02.26@2x] Here is my rather ugly regex with a capture group for the user IDs: [CleanShot 2021-09-28 at 13.02.35@2x] And there you go! [CleanShot 2021-09-28 at 13.02.47@2x] When I first saw this PR get merged, I was so exci…