Filtering is one of the most common techniques you'll use in working with data. In short, filtering allows you to hide portions of a dataset.
We'll introduce the Create a filter feature in Google Sheets, which allows you to easily filter data by values, conditions, or a custom formula.
Database and SQL
The SQL operators introduced in this lesson include:
- Boolean Operators – a filter that outputs TRUE or FALSE
- <> or !=
- Logical Operators – a filter that's "flexible". Search for multiple values, text, and more
- IS NULL
- Connection Operators – used to join Boolean and/or Logical operators together
This lesson will introduce the Filter feature in Looker.