Data filtering
Filter data based on set of criteria
Data filtering allows you to clean your data to only show specific subsets based on certain criteria. By filtering your data, you can quickly identify trends, patterns, and outliers, and make better-informed decisions, presented in a concise dataset.
1. To filter data from your columns, you must click on the filter button:
2. Click the first dropdown box and select any of the columns you wish to filter
3. Select your desired operator (Note: The operator options change depending on the selected column's data type). For String data type, the operators available are the following:
4. Insert your criteria
5. Press Apply Filters button or add more filters by pressing the "AND" or "OR" buttons, depending on the logic you want to specify.
For example, we want to fetch deals "won" in Columbia. Then, our filter should look something like this:
But if we want to fetch deals "won" in Columbia AND in the Philippines, then it should be something like the below: