So If I have two tables in my MySQL DB as the pictures attached, is it possible to have a variable where I can query the two departments (or choose from the dropdown menu either 1 or 2)?
I tried to do it with MySQL with no success, and the documentation doesn’t provide examples for MySQL variables.
So in short, I want to create two variables as follow:
-Variable (drop down menu) and query to choose different tables, where in my graph I can combine and compare for example (value1_dep2.department2 and value1_dep1.department1)
-Variable (drop down menu) and query to choose the year, so I can compare the same table value for different years for example (value1_dep1 in 2019 vs value1_dep1 in 2020)