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

CapriceW
8 - Asteroid

Here goes!

Karam
8 - Asteroid

My solution ..

sidneyjacobs
7 - Meteor

Preview of the workflow:

Spoiler
workflow.PNG
EW
11 - Bolide

This was harder for me than expected!  Still fun and helpful.

 

Spoiler
I tried for way too long to use a running total, but I couldn't get it to make sense.  I finished right away by switching to using Generate Rows.  

048EW.PNG
ipeng
8 - Asteroid

My solution. I have had problem calculating the allocation/fulfillment. The ABS() comment in solution is a great approach! 

JamesMA
Alteryx Alumni (Retired)

I found this very tough but eventually got it 99% correct, just two of the values for the 3rd task aren't quite the same but I can't work out why!

 

Any help would be much appreciated!

 

Spoiler
Week 48.PNG
KMiller
8 - Asteroid

Solution attached

RolandSchubert
16 - Nebula
16 - Nebula

My solution

archietao
8 - Asteroid

My solution:

 

ponraj
13 - Pulsar

My solution!

 

Spoiler
Challenge 48.PNG