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
Sorry, no flair for me. The boss says he's going to need me to come in on Saturday and he's going to need me to go ahead and come in on Sunday too.
Spoiler
Process
- Create spatial points
- Create trade areas
- Append 5 and 8 mile trade areas
- Find the outer ring (5-8 mile trade area) using spatial process tool
- Find customers where target touches or intersects universe (the trade areas)
Repeated process for both 0-5 and 5-8 miles....
- Calculate trade area in square miltes
- Summarise (group by customer segment and area count number of customers
- Calculate customer density
- Sort and clean-up
- Create and render table as pdf
- Create spatial points
- Create trade areas
- Append 5 and 8 mile trade areas
- Find the outer ring (5-8 mile trade area) using spatial process tool
- Find customers where target touches or intersects universe (the trade areas)
Repeated process for both 0-5 and 5-8 miles....
- Calculate trade area in square miltes
- Summarise (group by customer segment and area count number of customers
- Calculate customer density
- Sort and clean-up
- Create and render table as pdf
Check out my video solution too: https://www.dataprepsolutions.com/2020/01/alteryx-weekly-challenge-197.html
