Skip to main content

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.

aggregate skill menu

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.

compute

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 columns that you want to pivot on.
  3. Select the column to pivot on.
  4. Select the columns to create pivot rows from.
  5. Select the columns to create pivot columns from.
  6. Click Submit.

pivot

Once submitted, the pivot table appears in the Chart tab. You can sort the pivot columns and rows in ascending or descending order by clicking the corresponding arrows.

pivot