Overrides + Value Mappings --> RegEx not working

[browne]

• What Grafana version and what operating system are you using?
  Grafana v8.2.1 (88622d7f09) on Windows.

• What are you trying to achieve?
  I am trying to colour a whole column in a table.

• How are you trying to achieve it?
  Overrides + Fields with name + Value mappings + RegEx
  
  .
  

  

• What happened?
  Nothing, when using “RegEx condition”. No matter what I type in the RegEx field it doesn’t match anything! It doesn’t even match wildcards.
  When doing the same with “Range condition” it is working., but I need RegEx for the next columns.

• What did you expect to happen?
  That RegEx to be working fine also.

• Did you receive any errors in the Grafana UI or in related logs?
  No.

[fadjar340]

Hi,

you can check this:

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…

This helps me out to get my goal…

Regards,
Fadjar Tandabawana

[browne]

Thank you for the reply, but this is also not working.
It seems that RegEx in Overrides is broken.

[fadjar340]

Hi,

Try add this in the regex value:

^.*([0-9]).*

then in the Display text just put:

 $1

Regards,
Fadjar Tandabawana

[browne]

Not working. When using Range condition it works immediately.

[browne]

I just tested it with a row than only contains letters and no numbers.
RegEx is working there fine.

I think it has something to do with the type of the cell(s)?

EDIT:
The strange thing is that it matches words and letters while using RegEx “[0-9]”!?!?
Why? That doesn’t make any sense at all.

[michaelfilgate]

I’m using 7.5.6, and had zero joy using regex to override variables to use y-axis 2. I gave up, I was unclear if it was regex or flaws with the override itself.

[browne]

So it is not just me?
There is something wrong with RegEx in overrides…

[mattabrams]

@michaelfilgate to clarify, hopefully, the new regex-based value-mapping feature mentioned above was added 8.2:

Value mappings

[Guido]

Perhaps a bit late to the party, I was having the same issues in Grafana v8.3.6. Ranges were working normally but I was unable to get any responses from the regex value mapping.

Converting the column from numeric values to string solved it for me!

[horselessname]

Hello there.

I just converted the cell to string type, and added a override to match any number bigger than 0 in Grafana. Like this:

1. Convert to string
   

2. RegEx to match bigger than 0:
   

But the RegEx is not working for me…

[horselessname]

I’m having the same problem.

[olliecampbell]

Also struggling to get the Regex value mappings to work…

Mapping a positive or negative float doesn’t seem to work:

[leo69github]

Awesome !! It worked!