Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

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