Aggregate and Pivot

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

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 101 course

Group recipe lessons in the Visual Recipes 101 course

Pivot and Group recipes in the reference documentation.