1 Reply Latest reply on Aug 15, 2016 6:49 AM by Tom W

    Summarizing Quantity by last of date

    Sahaf Ibrahim

      Dear Jedis,

       

      I am looking to create an SQL like summary on Tableau, but I don't want to write a custom SQL. This is so that the user can deep dive into the details (Order Lines), if need be.

       

      An Order Items is what the customer places, Order_lines are the split of how we plan to ship them. I want the viz to calculate lead time by when we take to complete the whole order item; the original data calculates this per shipment.

       

      This is what I have:

       

      This is where I'd like to get to:

       

      Thanks in advance!