Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #197: Customer Density Reporting

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Spoiler
wfwf
Highlighted
Alteryx Partner

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
Highlighted
8 - Asteroid
 
Highlighted
Alteryx Certified Partner

Spatial tool are all ways fun to use!

Spoiler
FlowFlow

Lazy ReportsLazy Reports
Highlighted
Alteryx Certified Partner

My solution:

Spoiler
challenge 197.JPG
Highlighted
Alteryx Partner
Spoiler
jv1_0-1578386571805.png
Highlighted
8 - Asteroid

Good to refresh a bit of spatial! Thanks

Highlighted
8 - Asteroid

Here is my solution to this week's challenge

 

Spoiler
JamesCameron_0-1578392977825.png
Highlighted
Alteryx Partner

Solution attached.

Spoiler
ashissanpui_0-1578396814145.png

 

AShis

Highlighted
Alteryx Partner
Spoiler
AWC197.PNG

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