Definition
Sort and filter a big data set
A big data set is a table of hundreds or thousands of rows: one row for each case and one column for each property. You cannot read it row by row, so you let the computer help. Sorting puts the rows in the order of one column, smallest or largest first; rows with the same value keep their order. A filter keeps only the rows that fit a rule. After a filter always say how many rows are left of all rows. In Sort and filter you choose the column, the direction and the filter and see the first rows, the counts and a summary of the column.
Example
The orders of a web shop: 1 000 rows. Sorted by delivery time, largest first, the first row is order 40 with 99 days (red: impossible). The filter Region is North keeps 354 of the 1 000 rows and removes 646 rows → . As a percentage → , so 35.4% of the rows are left.





