Dashboard filter refers to more than one field

1

Hi,
I just got started with building dashboards and dashboard filters with variables and I totally love it. As most of my questions are in SQL I was wondering if one of you has an idea how to do the following:
I would like to have one filter (let’s say a text filter where I enter “Customer 1”) and what would happen in the background code is that the entry would then trigger 3 different fields.

So maybe to explain it better: as our queries are quite complex I have to have three filters: Client List, Client Name, Client Identifier. Right now I have to enter “Customer 1” in each of them, the code is like that:

and p.client_list = {{var1}}
AND c.client_name [[LIKE CONCAT (’%’,{{var2}},’%’)]]
AND p.client_identifier [[LIKE CONCAT (’%’,{{var3}},’%’)]]

The entry in the three filters is exactly the same: “Customer1” and you have to enter it in each filter to get the right result.
Do you have an idea how I could combine that that it shows only one filter in my dashboard? Happy for every suggestion!
Thanks, Eva

2

Does it work if you just use the same variable for all of them?

and p.client_list = {{var1}}
AND c.client_name [[LIKE CONCAT ('%',{{var1}},'%')]]
AND p.client_identifier [[LIKE CONCAT ('%',{{var1}},'%')]]
3

Yay that seems to work!! Thanks!