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

Usage

view: view_name {
  measure: field_name {
    precision: 10
  }
}

Hierarchy

precision

Possible Field Types

Measure

Default Value

6

Accepts

An integer

Definition

By default, Looker’s symmetric aggregate feature will return 6 digits after the decimal point of precision.

Set the precision to be higher than 6 if you need more digits after the decimal point for your calculations.

Set the precision to be lower than 6 when working with very large numbers, to avoid overflowing the decimal limit on your database.

For more information about symmetric aggregates, you can also see this Community topic.

Examples

The following example creates a field called average_value by averaging the value dimension, and maintaining a precision of 10 digits following the decimal point:

measure: average_value { type: average precision: 10 sql: ${value} ;; }

Top