Skip to main content Skip to complementary content

Inter-record functions

Inter-record functions are used:

  • In the data load script, when a value from previously loaded records of data is needed for the evaluation of the current record.
  • In a chart expression, when another value from the data set of a visualization is needed.
Information noteSorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

Suppression of zero values is automatically disabled when these functions are used.

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.

Row functions

These functions can only be used in chart expressions.

Column functions

These functions can only be used in chart expressions.

Field functions

Pivot table functions

These functions can only be used in chart expressions.

Inter-record functions in the data load script

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!