Table of Contents
STATISTICAL AGGREGATION
Category: Transform / Advanced
Description
This action generates one or more statistical calculations .
The calculations Statistical aggregation can perform are:
- Median
- Percentile
- Standard deviation
- Standard error
- Variance
Action settings
| 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
| 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.