Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #168: Dice Game - Born to Solve

Highlighted
11 - Bolide
Spoiler
 
Highlighted
8 - Asteroid
Spoiler
168.PNG

Highlighted
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
Highlighted
11 - Bolide

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).
Highlighted
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.

Highlighted
6 - Meteoroid

Enjoyed the challenge!

Highlighted
Alteryx Partner
Spoiler
AWC168.PNG

Really enjoyed this!

Highlighted
8 - Asteroid
Spoiler
bjkay30_0-1600197461684.png

 

Highlighted
Alteryx Partner
Spoiler
challenge_168_jc.PNG