community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #48: Calculating Distribution Priority

Alteryx Certified Partner

Solution attached.  Looking at the other solutions I should have used the running total solution to simplify this as opposed to using the Multi Row formula tool.

Alteryx Certified Partner

Since I am doing the challenges not in a chronological order I already encountered a very similar challenge that required to calculate items supplied. I find this one a bit more challenging as this challenge allows to make a partial fulfilment. 

 

Spoiler
In my solution I defaulted to my favourite multi row formula tool.
Screen Shot 2017-11-04 at 20.35.52.png


Fireball

Modified a macro from a past challenge to loop through each store by priority. Pretty fun!

Bolide
Bolide

Created iterative macro then answered the questions.  Fun!

Alteryx Certified Partner

Hopefully I've answered all three questions accurately. Solution attached.

 

Spoiler
challenge_48 - Snip.PNG
Asteroid

Solution attached.

Quasar

Solution attached.

Alteryx Certified Partner

struggled understanding how to assess priority, but the rework was minimal. a great challenge!

 

Spoiler
challenge48.png
Alteryx Certified Partner

Here's my solution.

 

Spoiler
solution_48.PNG
Quasar

Honestly the third question is pretty confusing. couldn't get an answer to match, but I couldn't decipher the wording