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
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_0486a595602542e4ad137f20c69f38df_.yxdb
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_1503d19f2d074063907574e87021f9e3_.yxdb
Single
Profile
Ship Date
MM-dd-yyyy
DateTime_Out
Convert Ship Date From:
MM-dd-yyyy
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_ee8d7e605d754b69911ad92cb3b7adc2_.yxdb
Single
Profile
Days to ship = DateTimeDiff([Ship Date],[Order Date],'days')
Subtotal per Order ...
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_90040446ae5e4b4b8e667beee22f3e9f_.yxdb
Single
Profile
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_0b00bca83f79495896e5644a5b3f0d71_.yxdb
Single
Profile
Order_ID - Ascending
C:\Users\s.tapankumarrath\AppData\Local\Temp\Engine_13900_4a9f0847de9c4782959ae41cdc68fbab_\Engine_18308_97b4b9bcfa0040f3978f0f0de94fc5ad_.yxdb
Single
Profile
Horizontal
Practice Exercise 3