Weekly Challenges

SharonNkn · ‎06-21-2019

It's my first time joining weekly challenge!

kshashank03 · ‎06-21-2019

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.

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()ENDIFMake sure that you group by the record ID you used as your unique identifier in the previous steps.

BUD · ‎06-21-2019

Bdonahue · ‎06-21-2019

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 · ‎06-21-2019

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

Spoiler

manojeaswaran · ‎06-21-2019

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