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

JoeM
Alteryx Alumni (Retired)

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.

CharlieS
17 - Castor
17 - Castor

Love the spatial challenges!

JoBen
11 - Bolide

Cheers!

Spoiler
Challenge_149.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
CamodCPA
8 - Asteroid

This was a fun one!

 

 

Spoiler
Capture.PNG
jdunkerley79
ACE Emeritus
ACE Emeritus

Went for a Spatial Formula approach...

Spoiler
2019-01-21_21-34-44.jpg

Overlap:
ST_Area(ST_Intersection([TradeArea],[SpatialObject_TradeArea]),"SqMi")
/
ST_Area([SpatialObject_TradeArea],"SqMi")*100

Pct:
IIF(ST_Contains([TradeArea],ST_CreatePoint([LONGITUDE]/1000000,[LATITUDE]/1000000)),1,0)
Then just average :)
kat
12 - Quasar

Spatial challenges are always great :)

Spoiler
Challenge #149.PNG
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

EW
11 - Bolide

This was fun!  Spatial challenges are great.  

 

 

Spoiler
149EW.PNG

fuzzymatch.PNG

 

rfergus
8 - Asteroid
Spoiler
image.png