Filtering Field Filter


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.


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.

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?

Hi @alantygel
Yes, since 0.37 with linked filters (aka chained filters):

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?

@alantygel Okay, there’s requests for that - upvote by clicking :+1: on the first post of each issue:

1 Like