---
schema_version: "1"
id: 8b15331ff89be8c610a76238ff0aa243e3cda82489f2c06d48edf52002d1a31b
title: SAQL Functions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: b659e78c3d9a0691570b068235ca8e29ac4c728413cbcb68fec90e43741f68a9
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# SAQL Functions

Use functions to perform complex operations on your data.

- **[Aggregate Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-functions-aggregate.md)**


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

- **[Date Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-functions-date.md)**


    Use SAQL date functions to perform time-based analysis.

- **[Time Zone Date Functions](https://developer.salesforce.com/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](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-cfy.md)**


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

- **[String Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-functions-string.md)**


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

- **[Math Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-functions-math.md)**


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

- **[Windowing Functions](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/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](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/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.