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 #83: Pop-Tart and Beer Pairings

cgoodman3
14 - Magnetar
14 - Magnetar

This makes me want to try pop tarts and beer!

Spoiler
Challenge 83.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
wwatson
12 - Quasar

My solution

RWvanLeeuwen
11 - Bolide

I have three records difference with the output, but I am unsure how this happened.

 

Have a look into my stepwise reveal of my thoughts and process

Spoiler
I tried excluding records from respondents for which [Beer] AND [Pop_Tart] AND [Score] were empty of null using the IsEmpty() function, but this resulted in too low a record count, so I kept it as is

Spoiler
are you sure you want to see how this challenge made me feel?

Spoiler
83.pngDrawing a happy face is quite difficult to do in Alteryx 🙂
OllieClarke
15 - Aurora
15 - Aurora

Now you've got me craving pop-tarts

Spoiler
challenge 83.PNG
piotrzawistowski
8 - Asteroid
 
Greg_Murray
12 - Quasar

Solution attached

joemkcarr
8 - Asteroid
 
Vidya26
8 - Asteroid

My Solution!!

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 83 is done!

 

Spoiler
challenge 83 JMS solution.PNG
T_Willins
14 - Magnetar
14 - Magnetar

My solution.  I added the bonus insights for Most Popular '10' rated combo and averages for each of beer, Pop Tarts, and combos.  It would be interesting to do some predictive analysis with what beer someone would like based on their favorite Pop Tart.

 

Spoiler

 Workflow 83.GIF

 

Spoiler
Workflow 83 - Insights.GIF