A user reports the following SQL error when selecting the discounted sale price field:ERROR: column...

Google LookML-Developer Question Answer

A user reports the following SQL error when selecting the discounted sale price field:

ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an aggregate function.

The developer checks the field definition and finds it to be:

measure: discounted_sale_price {

type: number

sql: ${sale_price} * 0.8 ;;

}

The developer also finds the LookML definition of the sale_price field to be:

dimension: sale_price {

type: number

sql: ${TABLE}.sale_price ;;

}

What isthe likely cause of the SQL error?

The discounted_sale_price field should have a group_by: yes parameter.

The sale_price field should be defined as a measure of type: number, not as a dimension.

The underlying database table does not have a fieldcalled sale_price.

The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.

Google LookML-Developer Summary

Price: $52.5 ~~$149.99~~