NEW QUESTION 77
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
Explanation
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:
In the data pane, click on the dropdown arrow, and choose create calculated field.
Let’s name this calculated field “ShippingDelay” (you can name it anything you want 🙂 )
2) Use the DATEDIFF() function, and pass it the arguments as follows:
‘day’ depicts that we want to calculate the number of DAYS between the two dates. The first argument is
‘start_date’ which is the ORDER_DATE (day the order was placed), the second argument is ‘end_date’, which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE – ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:
4) Phew! The hard part is done! Now let’s filter by Market to include only LATAM:
5) Drag Country to the view, and the new calculated field ‘ShippingDelay’ to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you’re choosing the Largest value*
Clearly, Mexico has the highest Shipping Delay!
