Filter dropdown with sql and variable

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?~

Use Field Filter in order to get dropdown boxes.

1 Like

many thanks,it solves part of problem

If dropdown does not appear, this might be helpful: