User Tools

Site Tools


transformations:statisticalaggregation

STATISTICAL AGGREGATION

Category: Transform / Math


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

SettingDescription
ColumnSelect the column to perform the selected calculations on.
FunctionsSelect 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 bySelect any columns to group the results by.


Function options

Function Options
PercentileSelect 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.


See also

transformations/statisticalaggregation.txt · Last modified: 2021/07/05 03:00 by craigt