Challenge #179: Calculating Order Status

[Kenda]

This time, instead of trying to get the fastest solve time or trying to create the workflow with the fewest tools, I tried to get this done with the fewest runs. Day to day, I'm constantly adding tools to the canvas then running the workflow to check the data as I build out workflows. So I wanted to challenge myself to trust my thinking and continue on adding tools without running so often. In the end, I got this done in 3 runs. 

Spoiler

[mbogusz]

Spoiler

Messy solution

[hanykowska]

I decided to look slightly differently at the challenge. Instead of flagging only the records in shipment data, I flagged all orders, as I thought it's also important to know which orders have not shipped at all but maybe should be on their way. Also added breakdown by parts with how much was shipped and how much is left to be shipped. Thanks for the challenge!

and so here are my results:

[alexm06]

This is my solution

[Arunas]

This is my solution

Spoiler

[danilang]

My solution

Spoiler

Dan

[Brian_Stoffel]

Some of my lines were different. I counted the shipments without orders as "received not ordered" instead of order complete. 

[maryas]

Here's my take on the challenge. 

Cheers !

Marya

[payam2]

It took me a little while to understand what's going on, but then all I had to do is to follow what was in the body of the question.