Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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.

SUBMIT YOUR IDEA

Challenge #168: Dice Game - Born to Solve

deviseetharaman
11 - Bolide
Spoiler
 
DanJ3
8 - Asteroid
Spoiler
168.PNG

jwlong91
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 ChallengeOriginal ChallengeAppAppMacroMacro
kelly_gilbert
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
kelly_gilbert_0-1595512134251.png

Macro:

Spoiler
kelly_gilbert_1-1595512196124.png
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).
justin_winter
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.

SMSatCFA
6 - Meteoroid

Enjoyed the challenge!

JennyMartin
9 - Comet
Spoiler
AWC168.PNG

Really enjoyed this!

bjkay30
8 - Asteroid
Spoiler
bjkay30_0-1600197461684.png

 

JethroChen
10 - Fireball
Spoiler
challenge_168_jc.PNG
CaminoPinan
8 - Asteroid

A bit tricky!