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

CaraI
Alteryx
Alteryx

A few more tools than the solution, but gets to all the answers.

 

Spoiler
48 workflow.jpg

Couple notes:
Select tools after the Create Points so the Centroids are Named - just a housekeeping thing.  
First Formula tools - sets the starting "Remaining Inventory" - it is possible to do this all in the Multi-Row tools, setting values for rows that don't exist to Null and then incorporating isnull() into the if then elseif, but IMO it over complicates the multi-row tool.  
danilang
19 - Altair
19 - Altair

Nice.  Spatial and analytics

 

 

Spoiler
Solution 48.png

Dan

 

OldDogNewTricks
10 - Fireball

Wow...lots of tools on this one.

OllieClarke
15 - Aurora
15 - Aurora

I'm not sure this is the most elegant solution, but it does work...

Spoiler
Challenge 48.PNG
JDelgado
8 - Asteroid

Did I miss something?

 

I just downloaded the start file to work on this one and it looks like I'm missing some data.

 

I have Retail Demand data, Retail Location data, and Warehouse Supply data - but I don't see any warehouse location data...

 

I need this information to solve the problem - unless I am misunderstanding something...?

MarMu
8 - Asteroid

 

Always a pleasure to muck about with the spatial tools.

Pretty straight forward after realizing that Running Sum was the way forward.

 

Spoiler
challenge_48_start_file_MarMu.png
JoBen
11 - Bolide

Cheers!

StevenBetts
8 - Asteroid

Here's my solution :)

 

Spoiler
Challenge 48.jpg
danrh
13 - Pulsar
 
Ozzy_Campos
8 - Asteroid

Solution attached, used an iterative macro, interesting to see the solutions that include a running total .