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 #197: Customer Density Reporting

PhilipMannering
16 - Nebula
16 - Nebula

Took me a while... you see it's not that I'm lazy, it's that I just don't care

 

Spoiler
wfwf
SueDonim
8 - Asteroid

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


MySolution.PNGCustomers 0-5miles.PNGCustomers 5-8.PNG
rmassambane
10 - Fireball
 
Sebenius
8 - Asteroid

Spatial tool are all ways fun to use!

Spoiler
FlowFlow

Lazy ReportsLazy Reports
Wouter
8 - Asteroid

My solution:

Spoiler
challenge 197.JPG
jv1
8 - Asteroid
Spoiler
jv1_0-1578386571805.png
paulburrows
8 - Asteroid

Good to refresh a bit of spatial! Thanks

JamesCameron
8 - Asteroid

Here is my solution to this week's challenge

 

Spoiler
JamesCameron_0-1578392977825.png
ashissanpui
9 - Comet

Solution attached.

Spoiler
ashissanpui_0-1578396814145.png

 

AShis

JennyMartin
9 - Comet
Spoiler
AWC197.PNG

Check out my video solution too: https://www.dataprepsolutions.com/2020/01/alteryx-weekly-challenge-197.html