Aggregate Function

<< Click to Display Table of Contents >>

Current:  Script > Yonghong Script Object Reference List > Top Level Scope Functions 

Aggregate Function

Previous pageReturn to chapter overviewNext page

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'])