Last tested: May 26, 2020
This error can occur when you have a measure that is not doing any aggregation, most commonly- a measure of type number that is referencing a dimension. For example:
dimension: id {
type:number
sql: ${TABLE}.id
}
measure: not_working {
type: number
sql: ${id}
See also SQL Error: "X is not a valid group by expression"
This content is subject to limited support.
I ran into the same thing. Is the behavior you describe expected, or a bug?
What is the recommended way to get around this problem?
@olof_evenvik you need to change measure type to sum/count/average