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 #48: Calculating Distribution Priority

Inactive User
Not applicable
 
mbogusz
9 - Comet
Spoiler
Two Out of Three Ain't BadTwo Out of Three Ain't Bad
TonyAdam
8 - Asteroid

The spatial part was easy. The other stuff was a bit tricky.

SueDonim
8 - Asteroid

No pithy comments on this one - just pushing through

 

Spoiler
Process:
- Create objects for stores and warehouses from lat and long
- Append
- Calculate distance from each store to each warehouse
- Sort by store and distance
- Select closest warehouse to each store
- Join with warehouse supply (this shows what supply is possible to give to each store, given constraint)
- Sort retail demand by item (asc) and demand (desc)
- Join with warehouse and store data
- Sort data
- Multi-row tool to calculate amount available of each item after higher priority items filled
- Second multi-row tool was not needed, could have used formula tool but no harm no foul
- Calculate unmet demand
- Sort and select highest unmet demand
- Calculate amount filled for each item
- Sort and select most filled item
- Multiply miles by number of items filled
- Aggregate miles for each item
- Filter out those travelled more than 400,000 miles

MySolution.PNG
JamesCameron
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1575270624390.png
DanielMS
Alteryx
Alteryx
Spoiler
Capture.PNG
johnsand
6 - Meteoroid

after hours of trying 🐵

danicahui
8 - Asteroid
Spoiler
Challenge 48 2019-12-13.jpg
mheinze
Alteryx
Alteryx

Leveraged Running Total and Multi-Row formulas.

Spoiler
mheinze_0-1576804602891.png
rmassambane
10 - Fireball