Superset / Preset : How to improve filters box performance

Filters are defined from a dataset, and usually, users select the same dataset that the table, but the same dataset can be large. Therefore, the filter performance will be affected as the filter box executes a select distinct "filter column" of the dataset. In this video, we show two tricks: 1- Materialize the filter options in a dimension table and build filters from this new dimension table (if the names of the columns are the same, the filter will apply in all charts) 2- Use a virtual dataset and filter fact table data to do select distinct on few rows. Also, use this trick to populate filters with values that have data, the top x value, or values that meet certain conditions.