Quick Calcs - Filter
Best way to filter data
Last updated
Best way to filter data
Last updated
Filtering
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.
In order to use the Quick Calc's filtering feature, you just have to select a column and then select the argument that you want to filter by. Once you click submit, it will automatically generate a filtered block. After the filtered block is generated, you can also hide 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