Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #15: Warehouse Shipped Miles

Debbie_N
Alteryx
Alteryx

Solution Attached!  😊

 

 

Spoiler
Challenge 15.png

 

 

Ncardenas
8 - Asteroid

Really cool way to learn spatial analytics!

Spoiler
Ncajamarca_0-1631299234596.png

 

TimothyH
Alteryx
Alteryx

 

 

 

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1631801448565.png

Creating the points and finding the closest warehouse in each example was the easy part. Then joining this to the original items data and summarizing the totals took me longer.

 

MichaelPilotFreight
8 - Asteroid

Check out my solution!

MichelleL
Alteryx
Alteryx

Nice spatial practice 🙂

TimN
13 - Pulsar
Spoiler
TimN_0-1632330384312.png

 

E_Robinson
7 - Meteor

Challenge 15 Solution

brandowd
8 - Asteroid

Please find attached my solution. I must admit that I looked at the solution in the end. I'd got all the tools and the workflow completely right but the totals were off. It was only realising that I needed to use the [Assigned] field (wasn't really sure what this was representing). So happy I was pretty much there just missing a small calculation.

 

Spoiler
brandowd_0-1632468658969.png

 

Steven33
7 - Meteor

Solution - Took the Assigned - Required to get a "Items Needed" and multiplied by the distance miles to get my result which is slightly different than the provided solution file.