Comment on page
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 clickAdd 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
toAnd
orOr
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 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 clickAdd a Filter Group
. - 4.Within the filter group, set the filter conditions and operator.
- 5.This filter group will be applied to your dataset.
Last modified 5d ago