AVG of binary flag for rate
Overall pick accuracy = 1 - error rate. Single number, alias `accuracy_pct`.
| Column | Type | Key |
|---|---|---|
| task_id | INT | PK |
| order_id | INT | |
| sku_id | INT | FK → dim_skus |
| zone_id | INT | FK → dim_zones |
| worker_id | INT | FK → dim_workers |
| wave_id | INT | |
| shift | TEXT | |
| pick_start_ts | TEXT | |
| pick_end_ts | TEXT | |
| qty_requested | INT | |
| qty_picked | INT | |
| pick_error_flag | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Pick accuracy is 1 minus the error rate. Average a binary flag and turn it into a percentage.
Single column.
Single row.