Filter widget only shows 5 options
Hello all,
I am seeing a problem with the Experience builder filter widget. I have a few hundred thousand records simply demoting the county and state in a single field, and I have a filter set up to show those records' county and state. There are a few hundred different combinations within this field. However, the filter widget only shows the first 5 options alphabetically with no settings that I could find to scroll through the potential filter options both in the SQL set up and in the widget itself.
The work around so far has been to manually type in the county you want to see data from, but even then it doesn't actually load until I hit "Search More", then it gives me the options I am looking for.
Is there any way to force the widget to search for all options right off the bat, or automatically "Search More" if the user types in a specified county? Thanks in advance!
