Top Values

In Excel, you can use the Sort tool and remove rows in order to extract the most extreme rows in a dataset.

In Dataiku DSS, the TopN recipe handles this task more efficiently than a Sort + Filter. Additionally, you can retrieve the top/bottom rows by values of a grouping column, and compute various measures of the ordering of each row.

See also

TopN recipe lessons in the Visual Recipes Overview course

TopN recipe in the reference documentation