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 #149: Market Overlap

Asteroid

This was a fun spatial challenge! My solution is the same as most of the others!

 

Spoiler
challenge_149_workflow.PNG
 
Alteryx Partner

I thought this was a good use of Spatial tools in a set of straight forward workflows.

Alteryx
Alteryx

Always like spatial challenges.

 

The formula tool has so many spatial features!

 

Spoiler
Workflow.png
Alteryx
Alteryx
Spoiler
Capture.JPG
Asteroid
Spoiler
Challenge 149.JPG
Alteryx Certified Partner

Here's my solution

 

Spoiler
Screenshot 2019-02-05 at 21.58.52.png

My solution! 

 

Spoiler
Challenged myself a bit with this one because it was a problem that was already familiar to me... so I tried to build the entire workflow to give me the correct answer WITHOUT running it until the very end. Sort of a "blind build", the goal being "one hit of the Run button = success". Was able to do it for Objective 1 with only one extra run (forgot to multiply my percentages by 100)... and then manged to make it to the right solution with just one run for Objective 2 (having learned my lesson with the percentages already!)

WeeklyChallenge149.JPG

Cheers!

NJ

Alteryx Partner

That was a nice one!

 

Spoiler
challenge149.PNG
Alteryx Partner

My solution attached.