Order Details
Final State
Initial State
Start 3.1.yxdb
Start 3.1.yxdb
Practice Exercise 3
Combine the customer information from the last exercise with "Order Details" to find the Total and Total Saved for each order.
Combine the customer information in "Start 3.1" with the "Order Details". Ensure both the "Order Date" and "Ship Date" columns are formatted as "date" datatype.
Find the number of days to ship after the order was placed for each line item. Also calculate the subtotal for each line item (discount and shipping are flat costs, not per quantity). Finally, find the Total cost for each order, the "Total Saved" for each order, and the minimum days to ship any line item within each order.
Order Details.yxdb
Order Details.yxdb
Final State - Exercise 3.yxdb
Final State - Exercise 3.yxdb
Ship Date
MM/dd/yyyy
ShipDate_Out
Convert Ship Date From:
MM/dd/yyyy
Days to Ship = DateTimeDiff([ShipDate_Out],[Order Date],"days")
Subtotal of Orde...
Order_ID - Ascending
Horizontal
Practice Exercise 3