Each table has a business grain. Customer orders can have several lines; receipt imports can contain repeated references; an empty arrival date means delivery has not happened. Aggregate only after choosing the correct grain. The schema browser shows the original fictional tables. Your query runs on a second dataset so a fixed answer cannot pass.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
Return fill_rate: total delivered units capped at ordered units on each line, divided by total ordered units. Zero deliveries stay in the calculation. Each table has a business grain. Customer orders can have several lines; receipt imports can contain repeated references; an empty arrival date means delivery has not happened. Aggregate only after choosing the correct grain. The schema browser shows the original fictional tables. Your query runs on a second dataset so a fixed answer cannot pass.