SAQL Functions | Analytics SAQL Reference

Aggregate Functions
Aggregate functions perform computations across all values of a grouped field.

Date Functions
Use SAQL date functions to perform time-based analysis.

String Functions
Use SAQL string functions to format your measure and dimension fields.

Math Functions
To perform numeric operations in a SAQL query, use math functions.

Windowing Functions
Use SAQL windowing functionality to calculate common business cases such as percent of grand total, moving average, year and quarter growth, and ranking.

coalesce
Use coalesce() to get the first non-null value from a list of parameters, or to replace nulls with a different value.