home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
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 returns 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, see the Help Center article, A simple explanation of symmetric aggregates.

Examples

This 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