Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #70: Trade Area Drivetime Radii

mascarenhas_lucas
8 - Asteroid

I really don't think this is the best solution ever and I don't have access to drivetime data, but here's my solution anyway. Thanks!

 

Spoiler
challenge_70.PNG
daniel_ferreira
8 - Asteroid

Follow my solution file solved...

 

I used US Peak Q4 2017 and the shared area has roughly the half area... or the traffic growed significanly in past 1,5 years or my workflow is not working as expected... lol

StevenBetts
8 - Asteroid

I've only got a Europe drivetime package, so I used distance instead. Managed to get something that was close(ish) to the example output using 12 miles.

dsmdavid
11 - Bolide

Didn't have the drive times and thought of this one as a back to shcool trying to get the perpendicular bisectors of the segments of the triangle...that would find the equidistant center of the three points and any area would be a circle with that point as its center...

Spoiler
70-01.png
kelly_gilbert
13 - Pulsar

Since I don't have drive-time data I used an average speed --> miles radius. Other than that, mine is the same method as everyone else's.

 

Spoiler
Capture.PNG
neilgallen
12 - Quasar

Areas don't match due to updates on the drivetime set (Late to the game here) but process was identical! I think the first time I've done exactly the same as the posted solution.

danilang
19 - Altair
19 - Altair

Two different ways to get to the same result in my solution.   

 

Spoiler
I went the multi intersection route until i learned that the summary tool supports spatial operations.  How Cool is that!

Solution 70.png

Dan

kat
12 - Quasar

Like some of the others I don't have drivetime data, so I went with using a set distance to get an approximation.

Spoiler
Challenge #70.PNG
Ukashi
8 - Asteroid

Did not have access to drive times so I've checked distances beetween offices and miles radiuses - and arbitrary come up with 11.5 miles (although initially I've used 15 km)

 

anyway thank you for challenge - good ocassion to use spatial tools.

 

Spoiler
image.png 

 

Ukashi
8 - Asteroid

Did not have access to drive times so I've checked distances beetween offices and miles radiuses - and arbitrary come up with 11.5 miles (although initially I've used 15 km)

 

anyway thank you for challenge - good ocassion to use spatial tools.

 

Spoiler
image.png