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 #8: Aggregate Consumer Purchases

angelakong
8 - Asteroid

My solution

HSogala
5 - Atom

Aggregate Consumer Purchases

RoGonzalez
5 - Atom

Hi All!

 

Please see attached my solution. I took exactly what the exercise explanation says and only considered tickets in which customers had Burger+Side+Drink or Pizza+Side+Drink. Anyone else found the case explanation confusing?

 

Thanks!

 

Ro.

AndrewSu
Alteryx
Alteryx

my take 🙂  Note that the file says to filter dates by JUNE, when it should be JULY. 

 

 

Neil_L
7 - Meteor

Tried to make the workflow shorter, and that's what I got finally.

Spoiler
challenge_8_spoiler.png
AlexBough
7 - Meteor

Thought i'd use the concatenate function in the summarise tool instead of crosstab!

Joe_Lipski
13 - Pulsar
13 - Pulsar

I used the contains formula

Joe Lipski
Miguel_Espino
Alteryx
Alteryx

My third challenge :D. ✌️(Three, pick number three my lord! Uhh uhh number three!)

ricki
8 - Asteroid

Fun challenge, definitely had me thinking through the various methods that could be used to approach this. 

Kanishkas5301
8 - Asteroid
Spoiler
Capture.PNG