SQL filter and dropdown filter

Hello,

I have a small question about filters on SQL queries.
I have an SQL query with a filter on an application, and in the dashboard the filter is well connected to this data. It works perfectly.
On the other hand, I have a second filter with a drop-down list, which displays the data from the SQL query, and that's where it gets stuck, because the SQL query expects a parameter that the filter does not send. Do you have any idea how to work around the problem? Because even filling in the filter in the dashboard and then opening the drop-down list unfortunately doesn't work....

EDIT:

In fact, this is what I want to do:

But not with countries, is that possible? THANKS

Thank you!

Hey, you might be running into this issue: Linked Filters should warn or not allow linking unless it will work · Issue #14595 · metabase/metabase · GitHub

When I tested it, it looks like when one (or both?) of the linked filters is a SQL question, the filters will not get linked.

So I think you'll have to use query builder (GUI) questions to access that linked filter functionality!