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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #14: Warehouse Distribution

Bolide

fun one!

Alteryx Partner

 

 

Spoiler
 14..png
Asteroid

Solution posted. 

Asteroid

I first approached this with a batch macro based on the group by priority rather than the iterative approach. 

 

Then I figured what the heck started over and made an iterative macro.

Alteryx
Alteryx
 
Alteryx Partner

I went down the multi-row formula route with this rather than building a macro. Seems like a simpler solution to me, though I'm not sure how robust it would be compared to a macro.

 

Spoiler
image.png
Asteroid
 

This was took longer than I expected. I ended up using the running totals to simplify the workflow greatly. 

Meteor

Here is my solution.

Asteroid

Solution!