Query ran in 0.8s — 5 rows
Last run: just now
Production Volume vs Target by Plant & Shift
| Date |
Plant |
Shift |
Volume (t) |
Efficiency |
vs Target |
| 2024-04-22 |
Steinbach |
Day |
31,200 |
94.2% |
+11.4% |
| 2024-04-22 |
Steinbach |
Evening |
28,400 |
91.3% |
+1.4% |
| 2024-04-22 |
Winnipeg |
Day |
14,800 |
92.5% |
+5.7% |
| 2024-04-22 |
Winnipeg |
Evening |
13,100 |
87.4% |
-6.4% |
| 2024-04-21 |
Steinbach |
Day |
29,700 |
90.1% |
+6.1% |
Show SQL
-- Generated by Looker · bigquery_prod · Explore: production
SELECT
DATE(production.production_date) AS `production.date`,
production.plant_name AS `production.plant`,
shifts.shift_name AS `shifts.shift_name`,
SUM(production.volume_tonnes) AS `production.total_volume_tonnes`,
AVG(production.efficiency_pct) AS `production.avg_efficiency`,
AVG(shifts.efficiency_pct) AS `shifts.avg_efficiency`
FROM `ops_prod.production` AS production
LEFT JOIN `ops_prod.shifts` AS shifts
ON production.shift_id = shifts.shift_id
WHERE
production.production_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY 1, 2, 3
ORDER BY 1 DESC, 4 DESC
LIMIT 500