Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
alteryx Community

Weekly Challenge

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 #168: Dice Game - Born to Solve

11 - Bolide
Spoiler

8 - Asteroid
Spoiler

8 - Asteroid

Really fun challenge!  I first tackled the challenge the simpler way using just three dice, but then I ended up creating an app that allows a user to enter the number of dice and number of sides per dice to dynamically find the most common score(s).

Spoiler
Original ChallengeAppMacro
13 - Pulsar

Some of my colleagues and I get together every other week to work on a Weekly Challenge (previously in a room together, but over videoconference for now!) This was the selected challenge this week, and since I had already done it (here), I went with a macro this time.

We decided to have the option of completing the challenge as given, or building a macro that would allow the user to enter the number of dice and number of sides on each die. We calculated the score = [highest side] * [2nd highest side] + [sum of remaining sides]

Outer workflow:

Spoiler

Macro:

Spoiler
Spoiler
I experimented with a single workflow (using generate rows to create a record for all possible combinations, and then using a formula tool to calculate the face value for each die, as I did in my original solution. In this case, the iterative macro solution was significantly faster (about 1/3 of the run time).
8 - Asteroid

This was super fun! I took one approach by running simulations and then another approach that created all combos and then calculated the value by multiplying all 3 values together, dividing by the minimum value and then adding back the minimum value! Kept it really nice and tidy in the solution.

6 - Meteoroid

Enjoyed the challenge!

9 - Comet
Spoiler

Really enjoyed this!

8 - Asteroid
Spoiler

10 - Fireball
Spoiler
8 - Asteroid

A bit tricky!