We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #149: Market Overlap

7 - Meteor

My solution:

Spoiler
8 - Asteroid
Spoiler

Green tools rule!

8 - Asteroid

9 - Comet
Spoiler
8 - Asteroid
Spoiler
8 - Asteroid

Very interesting as always

Spoiler
Process:
- 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

- 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

8 - Asteroid

8 - Asteroid
Spoiler
8 - Asteroid

My Solution:

8 - Asteroid

My Solution: