Aggregate and Pivot

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

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

In Dataiku, 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 – it’s like creating an Excel pivot table without specifying any Columns fields.