Knowledge Drop

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

  • 7 July 2021
  • 2 replies
  • 3833 views

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.                

 

 


2 replies

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?

 

Userlevel 7
Badge +1

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

Reply