Transforming data

Building challenge

With your shipments and delivery data combined, calculate expected delivery dates, flag late shipments, and filter down to only the shipments that missed their SLA by 2 or more days. Copy and paste this prompt into Parabola:

First, calculate a new column called "Expected Delivery" by adding "SLA_Days" days to "Order_Date".

Then calculate a new column called "Days Late" as the number of days between "Expected Delivery" and "Delivery Date".

Next, add a "Delivery Status" column:
* If "Days Late" is greater than 0, set it to "Late"
* Otherwise set it to "On Time"

Finally, filter to only keep rows where "Delivery Status" is not blank.

Overview

Building fundamentals

Transforming data

Building challenge