Suppose I have two Saved Questions produced by the SQL:
Q1:
SELECT exchange, product, day, trading_volume_daily
FROM trade_table
[[WHERE product = {{product}}]]
Q2:
SELECT
exchange,
SUM(trading_volume_daily)
FROM {{#1}}
GROUP BY exchange
where {{#1}}
refers to Q1.
Nice! I can put it on the same dashboard.
But now I want to add filter to Q1 for product
to check the volumes on exchanges for certain products. I want both Q1 and Q2 to be affected (even though Q2 doesn't have this field, it aggregates over data in Q1 which is filtered).
Is it possible to do it using the filters on the dashboard? Because for now I haven't found the way to do it.