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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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

DaisukeTsuchiya
12 - Quasar

Interesting challenge! All Task done.

 

Spoiler
キャプチャ.JPG

キャプチャ1.JPG

キャプチャ2.JPG

キャプチャ3.JPG

キャプチャ4.JPG

  

kelvinlaw
8 - Asteroid

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
Alteryx

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
15 - Aurora
15 - Aurora

My solution. All tasks done.

 

 

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

269-3.jpg Advanced, 

  

OllieClarke
13 - Pulsar
13 - Pulsar

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
8 - Asteroid

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
12 - Quasar

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