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 #269: Population DenCities

DaisukeTsuchiya
14 - Magnetar

Interesting challenge! All Task done.

 

Spoiler
キャプチャ.JPG

キャプチャ1.JPG

キャプチャ2.JPG

キャプチャ3.JPG

キャプチャ4.JPG

  

kelvin_law1
9 - Comet

Here is my solution for all 3 tasks and their outputs:

Spoiler
kelvinlaw_0-1621924208161.png

Task 1:

kelvinlaw_1-1621924283641.png

Task 2:

kelvinlaw_2-1621924337151.png

Task 3:

kelvinlaw_3-1621924374168.png
kelvinlaw_4-1621924414469.png

 

 

Sashikumar
8 - Asteroid

My Solution.

Spoiler
ch269.PNG
Maskell_Rascal
13 - Pulsar

Great practice on spatial and reporting tools! I only did the Beginner/Intermediate challenges for now. Will have to revisit the Advanced later. 

 

Solutions:

Spoiler
Task 1 Output:
Maskell_Rascal_0-1621956909848.png


Task 2 Output:

Maskell_Rascal_1-1621956945576.png

 

Workflow:

Spoiler
Maskell_Rascal_2-1621957033262.png

 

Cheers!

Phil

TonyA
Alteryx Alumni (Retired)

This was a great challenge! It's not often we get to play with the Data Investigation tools. I attached my solution without the data to keep the size down.

Spoiler
TonyA_0-1621975193726.png

 

RolandSchubert
16 - Nebula
16 - Nebula

My solution. All tasks done.

 

 

Spoiler
269-1.jpgBeginner 
269-2.jpg  Intermediate

269-3.jpg Advanced, 

  

OllieClarke
15 - Aurora
15 - Aurora

Here's my attempt at this challenge:

Spoiler
OllieClarke_0-1622020359357.png

I approached the 'intermediate' question by drawing a trade area around each lsoa the size of its population in metres. This didn't give me the same answer as the prompt, but it looked close-ish 😂

OllieClarke_1-1622020542414.pngOllieClarke_2-1622020557787.pngOllieClarke_3-1622020575066.pngOllieClarke_4-1622020586881.png

Spoiler
Edit: having now been reminded of the weighted avg tool I've got the correct way of doing it:
OllieClarke_0-1622021118347.pngOllieClarke_1-1622021137109.png

 

 

 

alexnajm
17 - Castor
17 - Castor

Maybe I'll get to the Advanced part another time... otherwise very fun challenge!

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1622063991685.png

 

phottovy
13 - Pulsar
13 - Pulsar

More reporting fun! The scatterplot becomes more interesting with a log transformation:

 

Spoiler
I took a brute force approach to task #2:
269.png

Task 3 reports:
269_p1.png269_p2.png