Filter
Abstract
Use the filter tool to to explore a subset of your data.
Keep data that passes logical tests.
When to use this tool
Use when you want to explore a subset of your data.
Example
In this example, we have a data set that contains customer IDs and an NPS score.
CustomerID | NPS |
|---|---|
2453 | 2 |
3243 | 4 |
3452 | 10 |
5324 | 6 |
4324 | 8 |
Let's say we want to explore data only for customers considered "detractors" (a score of 6 or less). We can remove the rows we don't need by using the Filter tool:
In the left side literal or column field, select or type "NPS".
Select or type "Less Than or Equal".
In the right side literal or column field, type "6".
As a result, the data set now looks like this:
CustomerID | NPS |
|---|---|
2453 | 2 |
3243 | 4 |
4324 | 6 |