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
Ship Date2
Convert Ship Date From:
MM/dd/yyyy
C:\Users\u814422\AppData\Local\Temp\Engine_25180_f4fc64fcfc8545cda4b6f4497211eeea_\Engine_20440_57edceb413d244ef9ed27b1657ceee05_.yxdb
Single
Profile
Total Cost = [Unit_Price]*[Quantity_ordered_new]+[Shipping_Cost]-[Discount]
Days...
Horizontal
Practice Exercise 3