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 #172: 2019 Grand Prix US - Heat 3

chris_ramsay_dup_425
8 - Asteroid

Here's my solution.

Thanks,

Chris

dombaikamilla
8 - Asteroid
Spoiler
172.PNG
SueDonim
8 - Asteroid

Figuring out how to group the items took a while.  Had to get help to figure out how to group the items so I could count the households in the contiguous area.  Definitely didn't finish before the checkered flag, but otherwise got it.

 

Spoiler
Process:
- Combine spatial objects
- Poly-split into regions
- Record ID for the 5 regions
- Spatial Match where individual blocks are in region (where target within universe)
- Count Households (group by RecordID)
- Divide number of Households by 160 (and roundup using Ceil function)
- Clean-up

MySolution.PNG
tiffany_chen
8 - Asteroid

Do not get the result at the first time. Refer to other's solution and learned two new tools: Poly Split and Make Group. Fantastic learn!

Spoiler
Annotation 2019-12-25 182647.png
Carlo_SKay
8 - Asteroid
 
PeterA
Alteryx Alumni (Retired)

A good exercise... always like the spatial ones.

Spoiler
Snag_683a4a52.png

Snag_683a1fb7.png

 

riverotoledo_21
8 - Asteroid

My solution!

ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
paulburrows
8 - Asteroid

Took a while! 

rmassambane
10 - Fireball