Aggregate and Pivot

In Excel you can use pivot tables to compute aggregated column statistics.

../../../_images/excel-pivot-table.png

In Dataiku DSS, to produce a dataset equivalent to an Excel pivot table, use the Pivot recipe.

The Group Recipe can also produce aggregated statistics, but no columns are pivoted. Think of it as creating an Excel pivot table without specifying any Column fields.

See also

Pivot recipe lessons in the Visual Recipes Overview course

Group recipe lessons in the Visual Recipes Overview course

Pivot and Group recipes in the reference documentation.