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:
/_time|$Client/
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?
Thanks!