Aggregate

Aggregating helps to collect and summarize your data for analysis. You can aggregate your data in two ways:

• Using Compute to perform calculations and aggregations on one or more columns in your dataset.
• Using Pivot to create a pivot table.

note

When a skill is applied to a dataset:

• If the skill creates a new dataset, it will use the convention [dataset]_[Skill].
• If the skill alters your existing dataset, it will use the convention [dataset] v[x] to save to a new version.

Compute

You can use the Compute skill to perform various calculations such as averages and sums.

To compute an aggregation or calculation on a dataset, select the dataset to Compute, then:

1. Click Aggregate > Compute in the skill menu.
2. Select the aggregation you want to compute.
3. Select the column you want to compute.
4. Enter a new name for the column.
5. Optionally, click the + button to add additional aggregations to compute, or click the - button to remove additional aggregations.
6. Optionally, enter the columns to group by.
7. Optionally, enter the columns or values to sort by.
8. Click Submit to run the computation.

Pivot

Pivot tables quickly summarize large amounts of data. You can use the Pivot skill to create your pivot tables.

To create a pivot table:

1. Click Aggregate > Pivot in the skill menu.
2. Select the aggregate (such as an average) for the column that you want to pivot on.
3. Select the columns to pivot on.
4. Select the columns to create pivot rows from.
5. Select the columns to create pivot columns from.
6. Click Submit.