SAQL Functions | Analytics SAQL Developer Guide

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

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

Time Zone Date Functions
When you enable the time zone feature, you can use the fields of the DateTime and DateOnly type to access date information in the specified time zone. For example, if a user in New York runs a SAQL query, they see date information displayed in Eastern Standard time.

Work with Custom Fiscal Year Data
After inheriting custom fiscal years, SAQL queries support custom fiscal year data.

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.