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 #15: Warehouse Shipped Miles

Highlighted
Alteryx Partner

Fun challenge to learn about spatial tools.

Highlighted
9 - Comet

Wow, this one made me really think! I am not familiar with spatial tools, so this was a great way to learn them. 

 

Solution attached.

-AD

 

Spoiler
Unfortunately, I didn't realize you can define a custom Nearest Neighbor distance, so I created trade areas around the warehouses and then compared the nearest neighbors of the stores to those trade areas. After all that, I had to filter, summarize, join, calculate, and then summarize again to get a reasonable answer. Mine didn't match perfectly, but I was within a reasonable amount of miles, so I was content.

The funniest thing to me is comparing my results of ~20+ tools to some answers that had it in less than 5! Again, it was a great learning opportunity!
Highlighted
8 - Asteroid

Here it is

Highlighted
8 - Asteroid

Challenge solved!

Highlighted
8 - Asteroid

My solution :-)

Highlighted
7 - Meteor

Solution attached!

Highlighted
8 - Asteroid

Here's my solution, love the Find Distance tool.

Highlighted
Alteryx Partner

My Solution!

Highlighted
7 - Meteor

I had the same solution as the provided one. The only difference for me was I did not use a double for my formula calculation so my decimals differed slightly. This was a fun challenge, and having never used the alteryx spatial tools it was crazy to see the time saving ability of some of the tools versus using a traditional spatial program. 

 

Spoiler
workflow:
Challenge 15 workflow.PNG

output:
Challenge 15 output.PNG
Highlighted
8 - Asteroid

Wasn't totally clear that it was miles times number of items, but after that it was pretty easy!