{{ transformations:StatisticalAggregationAction.png}}
====== 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// <sup>*</sup> (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|:::| 
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\
=====See also=====
  * [[transformations:aggregate|Aggregate]]