You are here:
Fiscal Calendar Options for Data 360 Queries
Use standard or custom fiscal calendar options to configure how Data 360 queries handle fiscal years. With these settings, you can align query results with your organization’s fiscal periods rather than calendar years.
Data 360 queries can group, sort, and filter data by using fiscal weeks,
months, quarters, and years that match your business needs. Fiscal calendar options work with
the EXTRACT, DATE_PART, DATE_TRUNC,
DATEDIFF, and DATE_ADD functions when you use fiscal date
units.
For examples using the fiscal calendar options, see Data 360 Query Guide: Fiscal Calendar Options.
Standard Fiscal Calendar Options
Use these options to configure a standard fiscal calendar with consistent rules:
- fiscal_year_start_month: The first month of your fiscal year. Accepts values 1-12 (1=January, 2=February, and so on). The default is 1 (January). For example, if your fiscal year starts in April, set the value to 4.
- first_day_of_fiscal_week: The first day of your fiscal week. Accepts values 1-7 (1=Monday, 2=Tuesday, and so on). The default is 1 (Monday). The default is 1 (Monday).
- use_start_date_as_fiscal_year_name: This option controls fiscal year naming. Default is true. When true, a fiscal year starting April 1, 2020 is named "FY 2020." When false, the same period is named "FY 2021." The default is true.
Custom Fiscal Calendar Option
For more complex fiscal calendars, use the fiscal_period_table option. This option uses a lookup table that maps each day to specific fiscal periods, enabling highly customized fiscal calendars that don’t follow standard patterns. The table must contain date-to-period mappings for each day in your fiscal calendar.
Important: Choose either the standard options or the custom table approach. You can’t combine both methods, as this causes configuration errors.
Default Behavior
If you don't configure a fiscal calendar, queries default to the Gregorian calendar (January 1 to December 31). Updates to fiscal calendar settings can take up to 24 hours to appear in Data 360 queries.
