Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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 #408: Sainsbury’s Market Research

nSpire
10 - Fireball
Spoiler
image upload failed
olga_strubbe
11 - Bolide

What a fun challenge, thank you,  @SamanthaJHughes!  This was a great practice for spatial tools for me.

My solution is attached. 

2024-01-08_13-21-10.png

ggruccio
ACE Emeritus
ACE Emeritus

Fun Spatial Challenge!

 

Spoiler
Spatial Match then Sort

408.png

ferg_smith
8 - Asteroid

nice

ARussell34
8 - Asteroid

I chose the top 5 because boroughs 3-5 all had 6 locations and it would be important to know those to pick which of them should be the appropriate choice for potential expansion.

AR_408.png

JamesCharnley
13 - Pulsar
Spoiler
image.png

Seems familiar somehow

logdog0411
9 - Comet
Spoiler
Screenshot 2024-01-08 160422.png

Love a spatial challenge! Good training for the Advanced Cert. 

I added a heat map with the London boroughs tiled by # of stores.  

JosephSerpis
17 - Castor
17 - Castor

Great challenge @Samantha_Jayne takes me back to my Sainsbury's day when we first got Alteryx. I decided to answer this challenge but not using any of the tools from the Spatial tool category. 

 

Spoiler
Challenge_408.JPG
binuacs
21 - Polaris
Spoiler
image.png
Chris-Nienart
8 - Asteroid

Just picking the bottom 3 boroughs doesn't account for ties! Need to do a little more work to find at least 3 boroughs.

Spoiler
There are actually 3 boroughs tied for 3rd place.There are actually 3 boroughs tied for 3rd place.