If you notice that certain values are missing from your dropdown filter, it may be due to a limitation in how the filter populates its options. This article explains why this happens and provides a solution.

Understanding the Issue

There are 2 possible limitations that are causing only certain values to show in dropdown filters:

1. When a dropdown filter is populated, it pulls distinct values from the first 5,000 rows of your dataset. If your dataset contains more than 5,000 rows, some values may not appear in the filter options.

2. We set a 5,000 value limit on the dropdowns for performance purposes. If you'd like this number adjusted, we can adjust this on our side for you. Please reach out to support@explo.co or your support contact to request a change.

Solution to issue #1

Create a Separate Dataset for Filter Values

To ensure all unique values are available in your dropdown filter, follow these steps:

1. Create a new dataset specifically for your filter values.

2. Use SQL with a SELECT DISTINCT statement to pull all unique values from your original dataset. The maximum number of values that can be in a dropdown are 5,000.

3. Use this new dataset to power your dropdown filter.

Example SQL Query

Here's an example of how your SQL query might look:

SELECT DISTINCT client_name
FROM your_original_table
ORDER BY client_name

Replace 'client_name' with the appropriate column name from your dataset, and 'your_original_table' with the name of your source table.

Implementing the Solution

1. Create a new dataset using the SQL query above.

2. In your dashboard, edit the dropdown filter settings.

3. Change the data source for the filter to your newly created dataset.

4. Save and refresh your dashboard.

By following these steps, you should now see all unique values in your dropdown filter, regardless of the size of your original dataset.