Analytics SAQL Developer Guide

Overview
Quick Start
Examples
SAQL Reference
SAQL Basic Elements
SAQL Operators
SAQL Statements
SAQL Functions
Aggregate Functions
Date Functions
Time Zone Date Functions
Work with Custom Fiscal Year Data
Group by a Custom Fiscal Year
Filter by a Custom Fiscal Year
Dates Outside Ranges Defined by Custom Fiscal Year
String Functions
Math Functions
Windowing Functions
coalesce
Query Performance
PDF

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Work with Custom Fiscal Year Data

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

Analytics supports custom fiscal year data by generating new fields that describe the custom fiscal year. Each of these new fields is named with the _Fiscal suffix. By working with these fields, SAQL supports custom fiscal year data.

Make sure that a dataset’s dataflow has run after inheriting custom fiscal years and before writing SAQL based on custom fiscal year data.

Each of the queries in the examples is based off the following dataset. These examples presume that Analytics inherited custom fiscal years that begin on February 1 and end on January 31. Custom fiscal years are defined from 2017 until 2022.

You can’t use custom fiscal year data with the fill or timeseries statements.

Note

Opportunity Name Created Date Amount
Widgets 2/15/2017 100
Widgets 1/25/2018 200
Widgets 3/30/2018 100
Widgets 3/30/2019 100
Widgets 3/30/2020 100
Widgets 3/30/2021 100
Widgets 3/30/2022 100