Challenge #15: Warehouse Shipped Miles

[ryan_b]

Fun challenge to learn about spatial tools.

[ADerbak]

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!

[Inactive User]

Here it is

[kcoulon]

Challenge solved!

[justynam]

My solution :-)

[jut]

Solution attached!

[Jim7]

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

[svenk]

My Solution!

[arussell_DV]

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:


output:

[justin_winter]

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