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

ductung2101
7 - Meteor

my solution

AndrewHoData
8 - Asteroid

Great to warm up my spatial brain again

AndrewHoData_0-1676861862472.png

 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_149_KU.png
olga_strubbe
11 - Bolide

@JoeM wrote:

We are 1 week out from challenge 150! Yes, that's right, a new badge is available starting next week for those we are up to date on all challenges!

 

In this week's challenge, we are going to be doing some calculations for market overlap!

 

 

Objective:
A retailer wants to analyze overlap for his current location's trade area against future locations.

1: For each proposed location, determine the % overlap of the existing location (e.g. if a proposed location overlaps 60% of the existing store's TA, the answer is 60%).

2: determine what % of current customers live inside each of the proposed trade areas

Summary of Data:
Proposed Locations polygon layer
Current location polygon layer
Current Customers

Hints: Customer Lat/Longs are integers
When joining to check your answer, don't join on a Double or Float.


Spoiler
olga_strubbe_0-1678197174439.png

Nice spatial challenge, thank you! :)  Got me to practice 'Spatial match' tool which I am not so good at.  I am finally getting there :)

RobertOdera
13 - Pulsar

Here is my response - cheers!

Spoiler
RobertOdera_0-1678710709942.png

 

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1681808979875.png
bjkay30
8 - Asteroid

Here is my solution.

 

Spoiler
bjkay30_0-1682628240010.png

 

alacoume
9 - Comet

my solution:

lucaskro
8 - Asteroid
Spoiler
lucaskro_0-1683646418170.png

 

kaiserj
8 - Asteroid

😀