Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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