Filter and Sort

Data Table Column Menu

Row Zero makes it easy to filter and sort data tables. By default, all data tables have filtering and sorting built into each column, identified by the down arrow denoting the data table column menu. Filter/sort capabilities are not yet available for spreadsheet ranges.

Filter

To filter, click on the down arrow in the header of any column. In the filter menu, you can choose values to filter by, enter a numeric conditional, type a specific string, or filter by date. Filters can be stacked by clicking '+ Add filter. Once a filter is added, click 'Apply' to see the data set transform. To clear filters, click 'X Clear filters' in the filter menu. Filters can be added to many columns within a data set.

Sort

Sort is accessed by clicking the down arrow in the header cell of each column. Columns can be sorted by dates, strings, or integers.

"~" Filter/Sort Operator

To make calculations on filtered data tables easier, we created a special operator using the tilde ~ symbol that will update the values of functions as filters change the visible data in the data table. As an example consider a data table with 100 rows in which 50 rows have the value 1 and the other 50 have the value 2. The function =count(A0["Column1"]) will return a value of 100. When written with tilde =count(~A0["Column1"]) and the data set is filter to only rows with value 2, the function will return a value of 50. The tilde can be added and removed from a function using F4 in formula edit mode.