Filter dropdown with sql and variable

[summer02905]

I use sql and two variables,but when I filter in dashboard,
it's only can type text,and not have dropdown,
Does it can dropdown that or not?~

---

[Arvydas]

Use Field Filter in order to get dropdown boxes.

Field Filters: create smart filter widgets for SQL questions

[summer02905]

many thanks,it solves part of problem

[Arvydas]

@summer02905

oes it can dropdown that or n

If dropdown does not appear, this might be helpful:

Dropdown using SQL

If this is a Field Filter in your SQL question, then you have to go to Admin Settings --> Data Model --> Select table where you have "Company" selected from --> Open the settings of "Company" column --> under "Filtering on this field" select A list of values. [image]