fiscal_month_offset

LookML
Version

On this Page
Docs Menu

Go to Model Parameter List

Usage

- fiscal_month_offset: integer
an integer

Definition

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.

Setting fiscal_month_offset specifies the year start of all fiscal timeframes used in dimension_groups and in advanced matches filter settings.

  • fiscal_year
  • fiscal_quarter
  • fiscal_month_num
  • fiscal_quarter_of_year

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.

You also can use fiscal date references in individual date types for dimensions and filters. Typically, however, using dimension_groups is the better practice.

Examples

To set your fiscal year to start in April, add the fiscal_month_offset to your model file:

- connection: thelook ### INCLUDES ### - include: '*.view.lookml' - 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.

Still have questions?
Go to Discourse - or - Email Support
Top