Comment on page

Filter data

In DEX, you'll find a filter panel that lets you focus on subsets of your data for exploration and explanation.

Manage filters

Open and close filter panel
To open the filter panel:
  1. 1.
    Open DEX by clicking on the Explore button in the lower right of the cell.
  2. 2.
    Click the button for Edit Filters
To exit the filter panel, click Stop Editing Filters.

Add a filter

To add a filter:
  1. 1.
    Open the filter panel.
  2. 2.
    Click the button Add Filter.
  3. 3.
    Pick the column you will be filtering.
  4. 4.
    Pick the dimension you want to filter on or choose to Switch to String Filter.
Remove a filter
To remove a filter, click on the
icon to the right of the filter.
Alternatively, you can use the Clear Filters link to remove all filters at once.
Managing filters

Types of filters

Dimension filters

Dimension filters allow you to filter string data using categories within the data.
Dimension filter

String filters

String filters can be used for:
  • Simple case-sensitive string matching.
  • Advanced matching with Regular Expressions (regex).
String matching
Regex matching

Metric filters

Metric filters are available for numeric fields and filter data by range. They default to the min and max values of each metric.
Metric filter

Date filters

Date filters allow you to filter dates by range using a date picker. There are some helpful suggested values in the left column (ex. Past year):
Date filters

Learn more