SELECT list expression [field] which is neither grouped nor aggregated at

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

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”

2 Likes
2

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?

3

@olof_evenvik you need to change measure type to sum/count/average

2 Likes