I have a dashboard with a multiselect filter for Application Name.
The filter is populated from a lookup that contains more than 2000 different application names.
The query to get the application name is very simple and takes less than a second:
| inputlookup applications.csv
| dedup "App Name"
| sort 0 "App Name"
However – once I click on the filter in order to choose a value – it freezes the dashboard for a while until I can select from the filter.
BTW - I need the option to view all applications by default, so it will not help to add another filter before, that will divide the applications to smaller buckets