Filtering Field Filter

1

Hi,

I have an SQL question where I want to use a Field Filter variable. However, I don’t want every value of the selected table to be listed on the dropdown (or autocomplete); just some of them.

Example:

I have a variable called state in my SQL query, but in my database base I have a table called terms, which contains the term name and the category it belongs to.

TERMS TABLE
Id | Name | Category
0 | Rio de Janeiro | State
1 | Minas Gerais | State
…
28 | Caldas | City
29 | Recife | City
…
In my dropdown, I only want to show term names whose category is state.

It this possible?

2

Hi @alantygel
Yes, since 0.37 with linked filters (aka chained filters):
https://www.metabase.com/learn/building-analytics/dashboards/linking-filters.html

3

Hi @flamber,

Thanks a lot for the quick response. If I understood well, this feature only works in dashboards and you will always need another filter.

In my example, I don’t want to give the option selecting any category. I really want to restrict, from the beginning, the options available in the dropdown to a subset of all available values. And I also want to use this in questions.

It would be nice if I could use another question as input of a filter.

Is this fit for a feature request?

4

@alantygel Okay, there’s requests for that - upvote by clicking :+1: on the first post of each issue:
https://github.com/metabase/metabase/issues/5245
https://github.com/metabase/metabase/issues/6820

1 Like