Work with 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.