3 Replies Latest reply on Apr 21, 2017 5:43 AM by Jim Dehner

# Shipping performance

I'm sure I am missing something simple, but I need to ask for help.

I want to show shipping performance by order, by warehouse by day.

For example, per the attached workbook, order 100 is complete, but order 103 is not.

A complete order requires for all line items, shipped quantity = order quantity, and scheduled ship date = actual ship date.

I can create a performance graph at the line item level, but not at the order level.  In other words, I can show if a line is shipped complete per the criteria, but I don't know how to roll that up to the entire order.  If an order shipped 9 out of 10 lines complete, but missed on one line, the whole order should show incomplete.

The attached workbook is what I want to display (count distinct of order number per day per warehouse), but also add the performance line

What I want to calculate is number of orders (not lines) per warehouse per day.

So I would end up with the bar graph I have, and then a line showing I shipped 50% on this day, and 75% on that day, and so on.

Thank you,

Chris

• ###### 1. Re: Shipping performance

Hi Chris

I'm close to what you want - see below and attached

here are the key formulas

Ship date mat order date = { FIXED [Order Number], [Warehouse Name]: avg(

if [Scheduled Ship Date]=[Actual Ship Date]then 1 else 0 END)}

Order qty complete?= { FIXED [Order Number],[Warehouse Name]: (

if sum([Order Qty])=sum([Shipped Quantity]) then 1 else 0 end )}

Order Complete =              if ([ship date match order date]) + ([Order  qty complete?]) = 2 then 'Complete' end

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Shipping performance

Jim,

Thank you for this.  FIXED was the function I was looking for.  I figured there was a way to pivot without displaying, but wasn't aware of that function.  I will work with this today, but I believe your knowledge has pushed me into the ballpark.

Thank you,

Chris

• ###### 3. Re: Shipping performance

Thanks Chris

Your problem was interesting - I have done some work with both distribution and manufacturing planning and have thought that Tableau was under utilized

in those areas

Jim

Also if you mark the response as correct or helpful it will close out the thread