ChartBaseDocs

Function reference

Every function, aggregation and window calculation, with signatures and examples.

The complete reference lives at /docs/functions.

It is generated from the engine's own function registry — the same definitions the formula builder uses to draw its palette and the compiler uses to type-check what you build. That means a signature in the reference is the signature the engine actually implements, not a description of it that has drifted.

How it is organised

  • Functions — called inside an expression, grouped by maths, text, date, logic and conversion.
  • Aggregations — summarise a column: sum, average, count, median, percentiles and more.
  • Window calculations — computed along a chart's axis: running totals, comparisons, rank.

Each entry lists its arguments, which types each accepts, what it returns, and worked examples.

Reading a signature

DATEADD(unit, date, amount) → same type as date
  • Arguments in order — note that unit comes first here.
  • [brackets] mark an optional argument.
  • … marks an argument that accepts several values.
  • The arrow shows the return type. "Same type as x" means it depends on what you passed in.
Function reference · ChartBase Docs