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

AngelosPachis
15 - Aurora

Challenge #269 is done.

 

Beginner

Intermediate

Advanced

 

Workflow :

 

 

Spoiler
AngelosPachis_0-1623522056308.png

 

 

Outputs :

 

Spoiler
output.png

 

 

 

kelly_gilbert
12 - Quasar

Whew, there were lots of parts to this one!

 

Overview:

Spoiler
kelly_gilbert_6-1623535944002.png

Task 1:

Spoiler
kelly_gilbert_0-1623535609819.png

Task 2:

Spoiler
kelly_gilbert_2-1623535727285.png

 



kelly_gilbert_1-1623535691736.png

Task 3:

Spoiler
kelly_gilbert_3-1623535798998.png




kelly_gilbert_4-1623535826814.png




kelly_gilbert_5-1623535871578.png

 

DawnDuong
12 - Quasar
12 - Quasar

My solution. The most time-consuming part is actually doing up the report. This Weekly Challenge is a good one to get some "mileage" on Reporting Tools. Thank you.

johnzrgu75
7 - Meteor
Spoiler
johnzrgu75_1-1623604090425.png

 

rmassambane
8 - Asteroid

Steve walks warily down the street

mbogusz
9 - Comet
Spoiler
Weekly Challenge #269 in the canWeekly Challenge #269 in the can
jpowellsd
Alteryx
Alteryx

This was a great challenge.  I've been working on it off and on for awhile - task 2 and 3b had me stumped.  Had to get help with the weighted average and population density, thanks @patrick_digan for your hint about Crew macro.  I was also trying to use the Shape_Are column, instead of ST_Area.  

 

Workflow:

Spoiler
jpowellsd_0-1625087746037.png

 

task1

Spoiler
jpowellsd_1-1625087876092.png

 

task 2

Spoiler
jpowellsd_2-1625088472633.png

 

task 3a

Spoiler
jpowellsd_3-1625088523793.png

 

task 3b

Spoiler
jpowellsd_4-1625088613113.png

 

RenatoV
6 - Meteoroid
Spoiler
Capture.PNG

FredNajjar
8 - Asteroid
Spoiler
FredNajjar_0-1625567824356.png
Luke_C
14 - Magnetar
Spoiler
Luke_C_0-1625839253048.png