Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
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
- 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
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!
