<< Click to Display Table of Contents >> Aggregate Function |
Function |
Description |
Example |
---|---|---|
Sum |
Return the sum of all data in the dataset |
Sum(col['sales']) |
Avg |
Return the average value in the dataset |
Avg(col['sales']) |
Count |
The number of data in the returned data set |
Count(col['product']) |
DistinctCount |
Returns the number of different values in the data set |
DistinctCount(col['product']) |
Max |
Return the maximum value in the data set |
Max(col['product']) |
Min |
Return the minimum value in the dataset |
Min(col['product']) |
Range |
Return the scope of the data set |
Range(col['sales']) |
Product |
Returns the product of a set of data |
Product(col['sales']) |
Median |
Returns the median of a given set of values |
Median(col['sales']) |
Mode |
Returns the mode in an array or data area |
Mode(col['sales']) |
SumSQ |
Returns the sum of squares of a set of data |
SumSQ(col['sales']) |
Quartile |
Returns the quartile of a set of data |
Quartile(col['sales'], 4) //quart is 0,1,2,3,4 |
PthPercentile |
Returns the percentage of P value in the numeric area |
PthPercentile(col['sales'], 10) //p is 0-100% |
Variance |
Returns the variance of a set of data |
Variance(col['sales']) |
PopulationVariance |
Returns the overall variance of a set of data |
PopulationVariance(col['sales']) |
StandardDeviation |
Returns the standard deviation of a set of data |
StandardDeviation(col['sales']) |
StandardError |
Returns the standard error of a set of data |
StandardError(col['sales']) |
PopulationStandardDeviation |
Returns the population standard deviation of a set of data |
PopulationStandardDeviation (col['sales']) |
SumWT |
Returns the sum of the weights of a set of data |
SumWT(col['sales'], col['profit']) |
WeightAvg |
Returns the mean of the weights of a set of data |
WeightAvg(col['sales'], col['profit']) |
Covariance |
Returns the covariance of a set of data |
Covariance(col['sales'], col['profit']) |
Correlation |
Returns the correlation coefficient of a set of data |
Correlation(col['sales'], col['profit']) |