Last tested: March 2021
You shouldn't do this. Symmetric aggregates are designed so that measure values are consistent no matter what joins are used in the query, and Looker does not support any solution that generates different measure values depending on what tables are joined.
When you set symmetric_aggregates: no
, all it does is disable any Measure that relies on symmetric aggregates and prevents it from running. It does NOT allow the measure to run a simple aggregation with no symmetric aggregates applied.
Symmetric aggregates are applied with aggregation types like type: sum
in LookML measures, but they are not applied when specifying an aggregate function in the sql parameter. So you can use a measure like the following:
measure: horrible_sum {
type: number
sql: SUM(${value}) ;;
}
Another option is to define all join relationships as one_to_one. Looker will assume that there are no fanouts created by your joins and will therefore never apply symmetric aggregates.
This content is subject to limited support.