Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

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.

Challenge #48: Calculating Distribution Priority

11 - Bolide

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.

9 - Comet

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.

10 - Fireball

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

ACE Emeritus

Created iterative macro then answered the questions.  Fun!

16 - Nebula

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

Spoiler
8 - Asteroid

Solution attached.

12 - Quasar

Solution attached.

8 - Asteroid

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

Spoiler
14 - Magnetar

Here's my solution.

Spoiler
12 - Quasar

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