community
cancel
Showing results for 
Search instead 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
capture.PNG
Meteor
Spoiler
Challenge 168 Screenshot.png

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


Screen Shot 2019-06-21 at 11.37.08 AM.png

   

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
challenge_168.PNG
Meteoroid

First challenge, very fun!

 

Spoiler
Challenge 168 Workflow.PNG

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

Spoiler
Capture.PNG

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

My solution