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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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

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

Submit Feedback

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
12 - Quasar

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!