Use 1 Dashboard Filter for 2 SQL Field Type Variables


I am joining two tables with a UNION ALL SQL query and have ended up with two date filters and two flow id filters in my dashboard. The SQL variables are Field Type and I cannot changed them to Text as I need to select multiple variables.

The setup works (see picture) but is not ideal, does somebody know if I can use 1 Dashboard filter for 2 SQL variables?

Thanks for your help.

Have you tried using the same name for the sql variable?

Hi Luiggi, really good Idea, but since I am joining two tables via UNION ALL I cannot use the same variable name as because it is ultimately a field type variable... So if I use the same variable name, I cannot set two separate field types from the two separate tables...

Any other ideas?