Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #179: Calculating Order Status

Highlighted
14 - Magnetar
14 - Magnetar

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
Capture.PNG
Highlighted
8 - Asteroid

 

Spoiler
Messy solutionMessy solution
Highlighted
8 - Asteroid

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:

image.png

 

Highlighted
7 - Meteor

This is my solution

Highlighted
5 - Atom

This is my solution

 

 

Spoiler
Capture.JPG

 

 

Highlighted
17 - Castor
17 - Castor

My solution

 

Spoiler
w.png

Dan

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Partner

Here's my take on the challenge. 

 

Cheers !

Marya

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

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.