STATISTICAL AGGREGATION

Category: Transform / Advanced

Description

This action generates one or more statistical calculations .

The calculations Statistical aggregation can perform are:

Setting	Description
Column	Select the column to perform the selected calculations on.
Functions	Select the calculations to perform. Options: Median, Percentile, Standard deviation, Standard error, and Variance. Each selected function will create a new column in the dataset.
Group by	Select any columns to group the results by.

Function	Options
Percentile	Select the percentile Threshold ^* (0 to 100) as well as the Percentile mode (Inclusive or Exclusive).
Standard deviation	Select whether to use a Sample or the full Population.
Standard error
Variance

^* Setting can be specified using a parameter.