I have a panel that needs to display a subset of data from another panel, based on the value of a Client variable. The data has a _time column and a column for each possible value of the Client variable:
I have set up a Filter By Name Transform with the following as the regex:
The _time column is recognized by this regex as expected, but the Client value is not. When I hardcode the Client value into the regex (
/_time|NV/), it works – just not when I use the variable. I have also tried escaping the $ character (
/_time|\$Client/) but it did not work.
How can I use a variable within a transform regex?