Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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 Alumni (Retired)

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