Weekly Challenges

Jean-Balteryx · ‎05-22-2020

Here is my solution !

MichaD · ‎05-26-2020

Nice exercise : )

My solution:

izamryan · ‎05-28-2020

Solved!

A great one for learning how to manipulate the spatial tools.

I think there might be a more elegant way to solve this, though. What happens when there are >5 locations? Like, say > 100?

Spoiler

My approach to this one was:
1. Calculate the 10 mile trade area
2. Test to see if each customer will be served by each one of the 5 identified locations and sum each location's served customer-people
3. Join sum of customer-people served with each of the 5 locations
4. Solve for the cheapest site, accounting for $cost, $benefit and $opportunity cost

Just watch out for the $benefiit ... $cost and $opportunity cost are -ve integers, but $benefit is a +ve integer.

There's probably a more elegant way to do deal with this where there are > 5 locations?
Because I used 5x formulas in the Formula tool to manually calculate the relationship of 1 customer : 5 locations.
So if there's 20 locations ... that's 20 formulas?
Maybe a more general approach is to use a Macro? Or load everything into a Python tool?
/shrugs

Gonna check out some of the other submitted solutions!

EDIT: aaand there IS an easier way to do this! 'doh!
This is one of the great things about the community ... it's like being able to peek over the shoulder of some of the Alteryx pro's and see how it's done. Amazing!

PS: I should've used a "Find Nearest" tool!

My approach to this one was:1. Calculate the 10 mile trade area2. Test to see if each customer will be served by each one of the 5 identified locations and sum each location's served customer-people3. Join sum of customer-people served with each of the 5 locations4. Solve for the cheapest site, accounting for $cost, $benefit and $opportunity costJust watch out for the $benefiit ... $cost and $opportunity cost are -ve integers, but $benefit is a +ve integer.There's probably a more elegant way to do deal with this where there are > 5 locations?Because I used 5x formulas in the Formula tool to manually calculate the relationship of 1 customer : 5 locations.So if there's 20 locations ... that's 20 formulas?Maybe a more general approach is to use a Macro? Or load everything into a Python tool?/shrugsGonna check out some of the other submitted solutions!EDIT: aaand there IS an easier way to do this! 'doh!This is one of the great things about the community ... it's like being able to peek over the shoulder of some of the Alteryx pro's and see how it's done. Amazing!PS: I should've used a "Find Nearest" tool!