Start Free Trial

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

cgoodman3
ACE Emeritus
ACE Emeritus

The distribution element was very similar to a previous weekly challenge, but adding in the spatial element added a nice twist.

Spoiler
Challenge 48.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
NoraW
7 - Meteor
Spoiler
C_48.PNG
TimothyManning
8 - Asteroid
Spoiler
48. Spatial.PNG
Took me a while to figure out how to remove the required numbers from the total count of each warehouse but I used a multirow formula in the end
rachelgatto
8 - Asteroid

Solved. 

RWvanLeeuwen
11 - Bolide

Took my quite some time to work it out, but for most of the time I was looking for the warehouse details which are a lot lower in the workflow canvas than I anticipated (and because of lunch time)

Spoiler
48.png
Greg_Murray
12 - Quasar

Solution attached

Greg_Murray
12 - Quasar

 

Whoops! Ignore the earlier post! Solution attached (for real this time).

dhtay
8 - Asteroid

Good challenge! It's my first time using spatial tools and the Running Total tool.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 48 is done!

 

Spoiler
challenge 48 JMS solution.PNG
EricR
Alteryx Alumni (Retired)

Here is my solution.  That one was fun!