error derived table

Looker Q&A Looker
,
1

Please, I want to create a derived table and bigquery as the database and i have this error :

Query execution failed: - SELECT list expression references column ID_TF_VTE which is neither grouped nor aggregated at [3:2]

Thank you

SELECT
 ID_SELL_DATE ,
 ID_ITEMS ,
 ID_STORE ,
 DATE(DATE_SELL) as DATE_SELL,
 SUM(Turnover) as Turnover ,
 SUM(GROSS_MARGIN) as gross_margin ,
 SUM(NB_TICKET) as nb_customer ,
 SUM(QTITY) as Qty 

FROM `ods.vente`
2

There’s not a GROUP BY clause in the main query of the derived table. One thing that you could do is copy that query and run it either in SQL Runner or directly in BigQuery. You can then use in LookML to create your derived table once it’s working without an error.