Filter Rows
This operation allows you to only display rows that fulfill a certain condition, or group of conditions.
For example, if you had a table with a price and cost column and only wanted to display rows where both the price and cost was greater than 1000, you could:
If you have multiple conditions they are always ANDed together - only rows that match all conditions will be displayed.
If you wanted to build a more complex filter condition, you can switch with the Use custom condition button. This will allow you to write any valid SQL condition, such as (price > 1000) OR (price < 1000 AND cost > 500).
Copy link