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!
What have you tried? What's the problem exactly?
It seems to me like a MIN or MAX on most of the fields would be the right approach.
If you're having problems, please upload a Tableau Packaged Workbook along with some specific questions and we can help!