[]
Specifies the type of aggregate to calculate over a group of values.
public enum Aggregate
Name | Description |
---|---|
Avg | Returns the average value of the numeric values in the group. |
Cnt | Returns the count of non-null values in the group. |
CntAll | Returns the count of all values in the group (including nulls). |
First | Returns the first non-null value in the group. |
Last | Returns the last non-null value in the group. |
Max | Returns the maximum value in the group. |
Min | Returns the minimum value in the group. |
None | No aggregate. |
Rng | Returns the difference between the maximum and minimum numeric values in the group. |
Std | Returns the sample standard deviation of the numeric values in the group (uses the formula based on n-1). |
StdPop | Returns the population standard deviation of the values in the group (uses the formula based on n). |
Sum | Returns the sum of the numeric values in the group. |
Var | Returns the sample variance of the numeric values in the group (uses the formula based on n-1). |
VarPop | Returns the population variance of the values in the group (uses the formula based on n). |