Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

SharonNkn
6 - Meteoroid

 

It's my first time joining weekly challenge!

Spoiler
capture.PNG
kshashank03
7 - 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. 
BUD
5 - Atom
 
Bdonahue
7 - 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

   

Bob_Tukker
6 - Meteoroid

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

 

Spoiler
Spoiler
manojeaswaran
6 - 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

vijaykumarmv
6 - Meteoroid
Spoiler
Spoiler
challenge_168.PNG
atperry30
6 - Meteoroid

First challenge, very fun!

 

Spoiler
Challenge 168 Workflow.PNG
patrick_digan
17 - Castor
17 - Castor

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
MYG
6 - Meteoroid

My solution