If you don't use the calendar year for your fiscal year, you can specify when your fiscal year begins for each model. Use
fiscal_month_offset to declare the number of months your fiscal year is offset from the calendar year. For example,
fiscal_month_offset: 1 will specify that the fiscal year starts in February.
fiscal_month_offset is typically set to a positive integer between 0 and 11 (inclusive),
fiscal_month_offset accepts any integer as a value, including negative integers. In the case of a negative integer, your fiscal year is set to the past. For example,
fiscal_month_offset: -3 causes Q1 of fiscal year 2018 to start in October of 2017. In the case of an integer greater than 11, your fiscal year starts a year or more into the future. For example,
fiscal_month_offset: 15 causes Q1 of fiscal year 2018 to start in April of 2019.
Any fiscal timeframes you create can be selected in the field picker and used to specify values for filters.
For advanced matches filter expressions, you can refer to fiscal years and quarters as absolute dates or relative dates.
When using relative dates for fiscal years, insert the word
fiscal in your filter expression for the quarter(s) or year(s).
When using absolute dates for fiscal years, use FY in front of the year:
When using absolute dates for a fiscal quarter, use the format shown in this example: FY2016-Q1.
To set your fiscal year to start in April, add the
fiscal_month_offset to your model file:
connection: thelook ### INCLUDES ### include: '*.view.lkml' include: '*.dashboard.lookml' fiscal_month_offset: 3
In the example above, the fiscal year will begin in April and the first quarter will include April, May, and June.