View the original community article here
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.