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!