Create order and shipping metrics

Let us view the total sales by average quantity. Many customers buy a single quantity of a product but combine that with other product types. The average quantity differs when calculated at the invoice level vs. across the entire business. This exercise will solidify your understanding of the relationship between the shipped quantity and the shipping cost.

We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_3_customer_metrics_solution.twbx from the Workbooks folder.