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 row, identifed by the down arrow denoting the data table column menu. Filter/sort capabilities are not yet available for spreadsheet ranges.
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 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.