Filter

The filter block allows you to filter out rows or columns of another block. The underlying data of the filter block comes from the block you select, so as you update the selected block with additional data, the filter block also automatically updates according to the filter arguments.

To filter data, create a filter block and then choose one of the other existing blocks on the canvas to filter. When you select that block, you get all the data from the original block in value form.

From there, you can filter a column by clicking on the column header and adding a filter. You can even stack filters between different columns.

Filtering in Subset is easier to understand than traditional spreadsheets. You don’t need to know if there are hidden rows that need to be accounted for. In Subset, Filters are its own block type that are dependent on a data source. The benefit of this method allows your filters to persist regardless of how the data changes and therefore filters are more dynamic and powerful.

Right now Subset supports the following filters.

Other

• Is empty

• Is not empty

• Remove Duplicates

Text

• Text contains

• Text does not contain

Date

• Date is

• Date is not

• Date is before

• Date is after

Numbers

• Equals

• Does not equal

• Greater than

• Less than

• Greater than or equal

• Less than or equal