User Tools

Site Tools


transformations:aggregate

AGGREGATE

Category: Transform / Basic


Description

This action calculates the aggregates for selected columns, grouped by another set of columns.

Available aggregations:

  • Sum
  • Count
  • Count only distinct values
  • Average
  • Min
  • Max
  • Any
  • Concatenate


Action settings

SettingDescription
CalculateSelect the column in which the values will be aggregated.
Aggregation methodSelect the aggregation method to be used on the values in the chosen column.
Group bySelect the column(s) in which the grouping of values will drive the aggregation.

You can aggregate more columns by the selected Group by columns by using the Aggregate by more columns option.

The output of this action is a dataset containing the "Group by" column, plus an additional column for each aggregation chosen.


Examples

Example 1: Find out the longest river on each continent.

Source table: The longest rivers in the world

River Length(km) Continent
Nile 6650Africa
Amazon 6400South America
Yangtze 6300Asia
Mississippi 6275North America
Yenisei 5539Asia
Yellow River 5464Asia
Ob 5410Asia
Paraná 4880South America

Action parameters:

Calculate: Length(km), Aggregation: Max
Group by: Continent

Output table:

Continent Max of Length(km)
Africa 6650
Asia 6300
North America 6275
South America 6400



Example 2: Find out the longest river, and the number of rivers, on each continent.

Source table: Same source table as Example 1.

Action parameters:

Calculate: Length(km), Aggregation: Max
Calculate: River, Aggregation: Count
Group by: Continent

Output table:

ContinentMax of Length(km)Count of River
Africa 6650 1
Asia 6300 3
North America 6275 1
South America 6400 2


Shortcuts

Fast ways to create the action:

  • Right-click on a column heading, and select "Aggregate", then select the aggregation method from the submenu.
  • Click the drop-down arrow in a column heading and select "Aggregate", then select the aggregation method.


See also

transformations/aggregate.txt · Last modified: 2021/04/02 01:47 by craigt