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

AngelosPachis
16 - Nebula

Challenge #269 is done.

 

Beginner

Intermediate

Advanced

 

Workflow :

 

 

Spoiler
AngelosPachis_0-1623522056308.png

 

 

Outputs :

 

Spoiler
output.png

 

 

 

kelly_gilbert
13 - Pulsar

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
13 - Pulsar
13 - Pulsar

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
10 - Fireball

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

 

Renato_7
6 - Meteoroid
Spoiler
Capture.PNG

FredNajjar
9 - Comet
Spoiler
FredNajjar_0-1625567824356.png
Luke_C
17 - Castor
Spoiler
Luke_C_0-1625839253048.png