Range functions

The range functions are functions that take an array of values and produce a single value as a result. All range functions can be used in both the data load script and in chart expressions.

For example, in a visualization, a range function can calculate a single value from an inter-record array. In the data load script, a range function can calculate a single value from an array of values in an internal table.

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.

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

Counter range functions

Statistical range functions

Financial range functions