community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #48: Calculating Distribution Priority

Asteroid

Here goes!

Alteryx Partner

My solution ..

Alteryx Partner

Preview of the workflow:

Spoiler
workflow.PNG
Asteroid

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
Asteroid

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

Alteryx
Alteryx

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
Asteroid

Solution attached

Highlighted
Alteryx Certified Partner

My solution

Asteroid

My solution:

 

Quasar

My solution!

 

Spoiler
Challenge 48.PNG