Filter data
In DEX, you'll find a filter panel that lets you focus on subsets of your data for exploration and explanation.
Open and close filter panel
To open the filter panel:
- 1.Open DEX by clicking on the Explore button in the lower right of the cell.
- 2.Click the button for Edit Filters
To exit the filter panel, click Stop Editing Filters.
To add a filter:
- 1.Open the filter panel.
- 2.Click the button Add Filter.
- 3.Pick the column you will be filtering.
- 4.
Remove a filter
To remove a filter, click on the .svg?alt=media&token=eb4c3768-231c-42d9-8375-6a228eb411b2)
icon to the right of the filter.
Alternatively, you can use the Clear Filters link to remove all filters at once.
Managing filters
Dimension filters allow you to filter string data using categories within the data.
Dimension filter
String filters can be used for:
- Simple case-sensitive string matching.
- Advanced matching with Regular Expressions (regex).
String matching
Regex matching
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 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
Last modified 7mo ago