Challenge #32: Alteryx '16 Grand Prix (Race 2, L2)

[GeneR]

This is the final lap in the Grand Prix series, last week’s (challenge #31) solution is posted HERE.

Here is the Scenario for this lap:  Now that I know the best four locations for me to visit (from last weeks exercise), I want to estimate how much it’s going to cost for me to take an Uber to each of the sites. If I start at this hotel, and head to the northern most location and head south to visit each surf site, how many miles will I drive? If Uber is $1.10 per mile, how much will that cost me?

The objective is to:  Identify the total drive distance from inspire to the northern point and work south to visit all four sites ending at the last site.  Calculate the Uber estimate.

*Remember to time yourself, contestants only had about ten minutes per lap.

[jdunkerley79]

 About 9 minutes this time...

Révélation

Thanks for posting all these great fun to see what they did (and fun to learn new stuff...)

[TaraM]

Thanks for playing along! Here's a solution to the final lap:

Révélation

[SeanAdams]

Loving these timed challenges :-) it may be worth @TaraM and @GeneR putting a time par value on each of the weekly challenges.

09:00 exactly on this one.

Same solution as provided and @jdunkerley79 except I used the spatial info component to get a simple distance answer.

[NicoleJohnson]

Feels like a few too many tools, but it worked... Aaaaand I didn't see the whole thing about the timed challenge part (since I'm doing these Grand Prix ones out of order), soooo I'm going to go with approx. 15 minutes? :)

Révélation

Solution: Calculate Distance from Hotel to each Surf Spot > Find the ones in the North, and sort by farthest away > Join back the one from the South > Add RecordID for TripOrder > MultiRow Tool to add field for HotelSpatialObj if TripOrder = 1 otherwise use the PriorDestination SpatialObj > Calculate Distance for each Trip > Formula to multiply by $1.10/mile > Summarize Distance & Uber Cost.

[estherb47]

about 8 minutes for this one!

Révélation

Spoiler

[LordNeilLord]

Not as efficient as other solutions and I went slightly over the 10 minutes..

Révélation

[nick_ceneviva]

Fun challenge

[Laurap1228]

Completed this one on my flight to San Diego! 

Note: I don't have drive time data so my solution may be different to the one provided.

Révélation

[Lorna_Eden]

Good challenge