precision

Usage

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

Hierarchy View File view Field Type 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 Understanding symmetric aggregates Best Practices page.

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} ;;
}