Range functionsON THIS PAGE
All range functions can be used in both the data load script and in chart expressions.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
Information note Range functions replace the following general
numeric functions: numsum ,
numavg , numcount ,
nummin and nummax , which should now be regarded as obsolete.
Basic range functions
RangeMax
RangeMax() returns the highest numeric values found within the expression or field.
rangemax (first_expr {, Expression} )
RangeMaxString
RangeMaxString() returns the last value in the text sort order that it finds in the expression or field.
rangemaxstring (first_expr {, Expression} )
RangeMin
Min() returns the lowest numeric values found within the expression or field.
rangemin (first_expr {, Expression} )
RangeMinString
RangeMinString() returns the first value in the text sort order that it finds in the expression or field.
rangeminstring (first_expr {, Expression} )
RangeMode
RangeMode() finds the most commonly occurring value (mode value) in the expression or field.
rangemode (first_expr {, Expression} )
RangeOnly
RangeOnly() is a dual function that returns a value if the expression evaluates to one unique value. If this is not the case then NULL is returned.
rangeonly (first_expr {, Expression} )
RangeSum
RangeSum() returns the sum of a range of values.All non-numeric
values are treated as 0, unlike the + operator.
rangesum (first_expr {, Expression} )
Counter range functions
RangeCount
RangeCount() returns the number of values, text and numeric, found within the specified range or expression.
rangecount (first_expr {, Expression} )
RangeMissingCount
RangeMissingCount() finds the number of non-numeric values (including NULL ) in the expression or field.
rangemissingcount (first_expr {, Expression} )
RangeNullCount
RangeNullCount() finds the number of NULL values in the expression or field.
rangenullcount (first_expr {, Expression} )
RangeNumericCount
RangeNumericCount() finds the number of numeric values in an expression or field.
rangenumericcount (first_expr {, Expression} )
RangeTextCount
RangeTextCount() returns the number of text values in an expression or field.
rangetextcount (first_expr {, Expression} )
Statistical range functions
RangeAvg
RangeAvg() returns the average of a range. Input to the function can be either a range of values or an expression.
rangeavg (first_expr {, Expression} )
RangeCorrel
RangeCorrel() returns the correlation coefficient for two sets of data. The correlation coefficient is a measure of the relationship between the data sets.
rangecorrel (x_values
, y_values {,Expression} )
RangeFractile
RangeFractile() returns the value that corresponds to the n-th fractile (quantile) of a range of numbers.
rangefractile (fractile, first_expr { ,Expression} )
RangeKurtosis
RangeKurtosis() returns the value that corresponds to the kurtosis of a range of numbers.
rangekurtosis (expr1
[ , expr2, ... exprN ] )
RangeSkew
RangeSkew() returns the value corresponding to the skewness of a range of numbers.
rangeskew (expr1
[ , expr2, ... exprN ] )
RangeStdev
RangeStdev() finds the standard deviation of a range of numbers.
rangestdev (expr1
[ , expr2, ... exprN ] )