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
Last updated