Filter By Condition

Use filter conditions like greater than, contains, starts with and much more to filter and explore your data.

Filter by condition allows you to apply filters to a specific column that remove rows from the dataframe by comparing these conditions to the values in the column you are filtering. To filter rows by condition.

1. Click on the Filter icon in the header you want to filter.

2. Click the Filter/Sort tab in the taskpane that opens.

3. Click the + Add Filter button, and then click Add a Filter.

4. Set the condition you want to filter on. Different filter conditions are available for different datatypes.

5. If you add multiple figures, optionally set the Operator to And or Or to change how these filters are combined.

6. Only rows where the filter conditions are met will remain in the dataframe.

Filtering to all values > 20.

Filter Groups

Filter Groups are aggregations of filters combined with an And/Or. This allows for more complex filters on the specific column.

1. Click on the Filter icon in the header you want to filter.

2. Click the Filter/Sort tab in the taskpane that opens.

3. Click the + Add Filter button, and then click Add a Filter Group.

4. Within the filter group, set the filter conditions and operator.

5. This filter group will be applied to your dataset.