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