{{:thematiques:informatique:capture_du_2018-04-03_22-37-42.png?400|}} SELECT count(distinct "pos_order__via__order_id"."partner_id") AS "count", date_trunc('week', CAST("public"."pos_order_line"."create_date" AS timestamp)) AS "create_date" FROM "public"."pos_order_line" LEFT JOIN "public"."pos_order" "pos_order__via__order_id" ON "public"."pos_order_line"."order_id" = "pos_order__via__order_id"."id" GROUP BY date_trunc('week', CAST("public"."pos_order_line"."create_date" AS timestamp)) ORDER BY date_trunc('week', CAST("public"."pos_order_line"."create_date" AS timestamp)) ASC