cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

## Challenge #168: Dice Game - Born to Solve

Alteryx Partner

It's my first time joining weekly challenge!

Spoiler
Meteor
Spoiler

Very interesting problem, they key is to figure out how to extract the second highest dice roll value from your three columns.

Spoiler
I used a transpose to turn the data into a format where I could easily use a Multi Row Formula:
IF [Row-1:RecordID] != [RecordID]
THEN ([Value] * [Row+1:Value]) + [Row+2:Value]
ELSE Null()
ENDIF

Make sure that you group by the record ID you used as your unique identifier in the previous steps.
Atom

Meteor

Fun One!  Did something Similar to this to build out business logic around every permutation of rules combinations.

Spoiler

Meteoroid

I just completed my first challenge.  Excited to start doing these on a weekly basis.

Spoiler
Spoiler
Meteoroid

Hi All,

This is the first challenge that I am trying to solve. I was at the Alteryx inspire conference 2019 and was inspired to make this a habit. Attached my solution. Please let me know your thoughts.

Thank you,

Manoj Kumar

Meteoroid
Spoiler
Spoiler
Meteoroid

First challenge, very fun!

Spoiler
Aurora

It's great to see so many responses! Here are my 2 solutions:

Spoiler

I thought it was fun to use the Getval and topnidx functions as I've never used those before:
Atom

My solution