InfluxDB: Regular Expression in Output

Apologies for the vague title but I’m hoping the example below makes it clearer

| Name | #Messages |
| US-In-Temperature | 5 |
| US-In-Delta | 10 |
| EU-In-Temperature | 2 |
| EU-In-Delta | 0 |

I want to write a query which creates a table that with regex pulls out the US/EU part and put it in a third column next to the Name and #Messages but for the life of me I can’t figure out how to get regex to work outside of WHERE statements. It’s fine if it’s through a transform rule also.

Thanks in advanced for the help!

You are using Discouraged schema design - Avoid putting more than one piece of information in one tag. I would fix schema design first - e.g. add location tag instead of hacking and finding workarounds later - like you have problem now in Grafana.

Thanks for the info! Sadly I’m not in control of the data so it isn’t possible for me to fix anything about the source data. Could I pester you for a workaround without modifying the source?