Filter By Condition
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.
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 9mo ago