Search box (filter) not working

Get Help
1

Hi!
I'm using metabase v0.37.4 and I'm having trouble with a filter. I want this result:

metabase_ex
metabase_ex755×472 51.1 KB

But my filter is working as a normal text filter. These are the settings:

config

my option is only none.

config2
config2576×584 15.8 KB

I have already reviewed my query and made sure that there is no alias in the variable. What I am missing?

2

I changed this:

ty
ty644×594 19 KB

and now the list is working :slight_smile: but when I change to search box it is not working :confused:

3

Hi @Helena
Please read this article:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
I would try to a newer release, which has several fixes to filter dropdowns:
https://github.com/metabase/metabase/releases/latest

1 Like
4

Hi @flamber :slight_smile:

Is there a way to show only the options according to another filter instead of showing all the options in the table?

Example:
I have two filters: one for category and one that shows the dropdown menu.

  • My X variable in category filter has options A, B, C and D
  • My Y variable in category filter has A and R options
  • The table has A-Z options

so I want to show only options A,B,C and D when I put option X in category filter and show only A and R with option Y.
I've already tried to vinculate the two filters...

5

I think I found the problem... the two filters are not in the same table :frowning: I did a LEFT JOIN