[]
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). |