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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #149: Market Overlap

Alteryx Partner

My solution:

 

Spoiler
Challenge_149_JP.png
Alteryx Partner
Spoiler
149.PNG

Green tools rule! 

Asteroid
 
Asteroid
Spoiler
challenge_149_solution_justindavis.PNG
Asteroid
Spoiler
2019-11-21 08_11_12-Greenshot.png
Alteryx Partner

Very interesting as always

 

Spoiler
Process:
Top thread:
- Create points for customer location (noting the lat and long as integers)
- Count number of customers (to allow % calculation later)
- Find intersection of customer location with the trade area of each proposed location
- Count number of customers in the trade area of each proposed location
- Append the number of customers in each trade area with the total number of customers
- Calculate % of customer overlaps
- Clean-up

Bottom thread:
- Find overlap of proposed store trade areas with current trade area
- Calculate area of proposed store trade areas
- Calculate area of existing trade area
- Append existing and proposed trade areas
- Calculate % of overlap of areas
- Clean-up

MySolution.PNG