3 Replies Latest reply on Oct 25, 2012 10:36 AM by hub.yoo

    Need assistance in building a quantity ordered VS quantity shipped visualization

    hub.yoo

      Hello esteemed tableau users,

       

      I am having trouble placing quantity ordered and quantity shipped on a viz. I have sales information with order number (serial number), Ship_date, Order_Date, Qty_Ordered, and Qty_Shipped.

       

      For an order number, I want to show number ordered on the day it was ordered, and quantity shipped on the ship day. The problem i am having is that when i use one date value, say order date in this case, the qty_shipped coincides with the order date, instead of the ship date.

       

      I tried using a calculation to select Order_date or ship_Date based on if Qty_Ordered or Qty_shipped is selected but i get an error message saying that If statements require boolean expressions. So tried "If Order_Date != Ship_Date then Ship_Date else Order_Date end" but that didnt work either.

       

      Is there an easy fix for this? Do I need to create a 3rd date field that is neutral and use that to base my ship_dates/Order_Date selection?