# SAQL Functions

Use functions to perform complex operations on your data.

- **[Aggregate Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-aggregate.md)**

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

- **[Date Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-date.md)**

  Use SAQL date functions to perform time-based analysis.

- **[Time Zone Date Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone.md)**

  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](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-cfy.md)**

  After inheriting custom fiscal years, SAQL queries support custom fiscal year data.

- **[String Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-string.md)**

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

- **[Math Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-math.md)**

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

- **[Windowing Functions](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-windowing.md)**

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

- **[coalesce](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-coalesce.md)**

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