Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
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!