Showing values in filter widgets that only match certain substrings or patterns

Use-case:

I have a field with thousands of values and only want to display values in the Filter Widget that match a certain portion of the value.

19%20AM

For example, let’s take a field called “region” that has 8 values.

00%20AM

Ultimately I would like to only show regions in the Filter Widget that start with “O”:

51%20AM

Example Walkthrough:

Step 1: Create a cloned field with the substring evaluation logic (i.e. region_substring_check)

39%20AM

In the Expression editor, evaluate your substring logic such that if there is a match that you display the value of the region (in this case), and if not display a blank value instead.

Make sure to Apply changes and Save the Dataset before going back to your Dashboard.

Step 2: Add new “region_substring_check” field as a Filter Widget to the Dashboard:

51%20AM

Step 3: Select any value that matched the substring logic, and the Visuals should update to include only records matching those values:

14%20AM

1 Like