Usage
view: view_name {
measure: field_name {
precision: 10
}
}
measure: field_name {
precision: 10
}
}
Hierarchyprecision |
Possible Field TypesMeasureDefault Value6AcceptsAn 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} ;;
}