User Guide Getting Started Help Center Documentation Community Training
New LookML
Old LookML
New LookML
Looker
  
English
Français
Deutsch
日本語
convert_tz

Usage

view: view_name {
  dimension: field_name {
    convert_tz: yes | no
  }
}

Hierarchy

convert_tz

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A Boolean (yes or no)

Definition

Looker has various time zone settings that convert time-based data between different time zones. Looker does time zone conversion by default. If you do not want Looker to perform a time zone conversion for a particular dimension, dimension_group (with type: time), or filter field, then you can use the convert_tz parameter. This can be useful for fields that are already converted to the appropriate time zone, or in some advanced situations where you need to avoid a double time zone conversion.

In general, time computations (differences, durations, etc.) only work correctly when you operate on time values that are all converted to the same time zone, so it is important to keep time zones in mind when writing LookML.

Examples

Do not perform time zone conversion for the local_created dimension group:

dimension_group: local_created { type: time timeframes: [time, date, week, month] sql: ${TABLE}.local_created_at ;; convert_tz: no }

Common Challenges

convert_tz: no applies only to a dimension, not to a filter that uses the dimension. In other words, filters always perform time zone conversion. When you specify convert_tz: no, time-based data values are displayed in the database time zone, but are filtered using the query time zone.

Because filters always do time zone conversion, a difference between the database time zone and query time zone could cause data to unexpectedly be included or excluded from a dataset. To avoid this, ensure that the query time zone is set to the same value as the database time zone.

If User Specific Time Zones is enabled, set the time zone drop-down menu (located next to the Run button on Explores, Looks, and dashboards) to the same value as the database time zone. If User Specific Time Zones is disabled, set the Query Time Zone to the same value as the database time zone.

Top