I have some data with critical attributes: Order number, Plant Name, Order Date, and Order Line Weight. What I'm trying to do is aggregate all the order lines onto what I'd consider a single "shipment" - one order number leaving one plant on a specific date. There are instances where an order sources out of multiple plants (due to minimal stock overlap) or where things may not be in stock at the same time, so differing days can't be reflected as one shipment. Once I have a shipment defined (unique string for Single Shipment in first column), I want to see the aggregate weight (Sum of Weight in pivot table) and if the weight is below 150 lbs, call it "Small Pack", if it's above 20,000 lbs, call it "TL" (Truckload), and if it's any value in between, call it "LTL" (Less than Truckload).
I mocked up some sample data in excel below:
What I'm trying to reproduce is the pivot table to the right. Someone showed me how to do LOD in Tableau which got me the "Sum of Weight" column:But what's eluding me is then taking that LOD and classifying it. I tried looking on these forums and found some helpful stuff, but couldn't get it to work. I tried two different formats:
Any help is greatly appreciated!
Sorry, I didn't catch the drag and drop doesn't work error message. Screenshots below:
