community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #70: Trade Area Drivetime Radii

Asteroid

Hi! Here my solution :)

I don't have the TomTom dataset, so I found the equivalent linear distance for that 30-minute-drive area

Asteroid

My solution

Spoiler
70.png

 

Highlighted
Asteroid

I don't have the spatial license. However, I compared to other approaches and I look like I took a similar approach. I did two paths. First path used spatial process tools and second path used the summarize intersection. Both had the same answer in the end. 

Spoiler
Challenge 70 Spoiler.PNG
Alteryx Partner

Tried my best to replicate the answer without having access to drivetime data...

Spoiler
challenge 70.PNG
Asteroid

Don't have the drive time data so used straight line distance instead.

Alteryx Partner

As numerous others has mentioned, this weekly challenge is difficult with out the availability of the Spatial Data Package to calculate driving distance.

 

So I brute forced my solution inspired by  @NicoleJohnson 

 

Spoiler
Since I did not either have access to the additional spatial data package needed to facilitate the Drive Time calculation in the Trade Area object, i did a kind of brute forcing my result to use an input of 11.56845615 Miles Radius

2019-02-20 13_05_55-Alteryx Designer x64 - challenge_70_solution_verakso.yxmd.pngThe WorkflowThis give me a result closest to the provided result, and is base on a area like this:
Map.jpgThe Area

 

 

 

Still Climbing
/Thomas

Asteroid
 
Asteroid

my solution

 

not using drive time

Pulsar
Pulsar
Spoiler
Capture.PNG
Alteryx
Alteryx

I finished the challenge without realizing the trade area tool could do drive times and that the Summarize tool could overlay spatial objects. I'm putting up my original solution anyway, but I learned a lot from this exercise.