Filter Autocomplete suggestions does not work in my metabase

Get Help
#1

I'm running on metabase 0.45.2 and have a table named products and a column with the name brand. I'm trying to create a filter that shows the average price per brand for the brand input via the filter. However, I do not see the autocomplete and must always type the brand name. The chart works well; autocomplete is the issue.

Beauty-data-·-Dashboard-·-Metabase
Beauty-data-·-Dashboard-·-Metabase871×636 13 KB

#2

can you provide:

  1. number of distinct values of the column
  2. is the question a gui or sql question
#3

Hey, There are 58 distinct values in the column. It is an SQL question I'm using the brand inside the place holder like {{brand}}

#4

is the filter a normal filter or a field filter? can you post the section of the sql question you're referring to?

#5

See the query below. Thanks a ton for taking time to help me

SELECT AVG(price) as avg_price 
FROM products 
WHERE brand = {{brand}};
#6

Use Field Filter and autocomplete will work properly.

#7

I tried that, see the image below. I'm getting a syntax error. but when I replace the placeholder with a brand name , it works.Also In the filter widget type, I don't see an option named category.

Question-·-Metabase
Question-·-Metabase1902×775 49.1 KB

#8

of course you will get syntax error if you will not use it properly:

#9

I read it multiple time, but still did not get what is wrong ?

#10

instead of using brand = {{brand}} just use: {{brand}}

#11

Not sure if it is just a bad day or if I'm terrible at this. But I did not understand what you meant by the above response

#12

:smiley: just remove "brand =" from you SQL in screenshot

#13

Thank you very much for tolerating me. You mean like the one below? .

SELECT AVG(price) as avg_price
FROM products
WHERE {{brand}}

#14

Exactly!

#15

Thanks, it worked. I spent a ton of time fixing this stupid issue. Part of the learning curve I guess

1 Like