Use 1 Dashboard Filter for 2 SQL Field Type Variables

Get Help
#1

Hi

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.

Screenshot 2023-04-23 at 14.23.22
Screenshot 2023-04-23 at 14.23.22806×85 7.11 KB

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.

#2

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

#3

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?