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 updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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
13 - Pulsar
Spoiler
Luke_C_0-1625839253048.png