The description seems ambiguous. The person that wrote this, does not recognize the fact, "# of products ordered", could really mean any...
1) Either the COUNTD(product_name)
2) COUNT(Product_name) or COUNTD(Order_ID)
If I were to guess, without asking for any clarification, I would go with option 2.
With regards to Dates, When you are dealing with 2 dates, you are dealing with 2 different dimensions. Recommended way is to have a bridging dimension/ Date Field that you can use. If that is not an option you can just drag both Ship and Order dates and synchronize the axis. Here is my attempt at displaying both. Highlighted yellow, is parts where we see there are Dates with Orders, more frequently than Dates with Shipments. (Probably, they were receiving orders over weekends as well. But they were shipping those only on weekdays).
Finally, the CNTD(ORDER ID) field has a running total table calculation in it, which is same as cumulative products ordered. (If you feel, a order can have multiple products in them, then feel free to use CNTD(Product Name) field instead.
Attaching the workbook as well.
Please remember to mark the thread answered, if its helpful.
Ship_Dt and Order_Dt.twbx 589.9 KB
Hello Karthik, and thank you so much for the explanation
Actually, the solution I have contemplates that bridge table you are talking about, so thanks for showing the other approach.
Now, with this approach of having the 2 dates on the view, how can we calculate the balance of shipments? Is it even possible? (RUNNING_SUM( COUNT([Order date order IDs]) ) - RUNNING_SUM(COUNT([Ship Date order IDs ] with the bridge table).