User Tools

Site Tools



Category: Transform / Advanced


This action generates one or more statistical calculations .

The calculations Statistical aggregation can perform are:

  • Median
  • Percentile
  • Standard deviation
  • Standard error
  • Variance

Action settings

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

* Setting can be specified using a parameter.

See also

transformations/statisticalaggregation.txt · Last modified: 2022/10/02 20:15 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki