Aggregation Functions
Aggregation Functions are primarily used to define Measures in the Aggregate stage.
Function | Description |
---|---|
pct | Percentage of records that match criteria |
freq | Count of records that match critera |
sum | Sum |
min | Min |
max | Max |
avg, mean | Mean |
median | Median |
var | Variance |
stdev | Standard Deviation |
validcount | Valid Count |