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
Asteroide

My solution

HSogala
Átomo

Aggregate Consumer Purchases

RoGonzalez
Átomo

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
Meteoro

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

Spoiler
challenge_8_spoiler.png
AlexBough
Meteoro

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
Asteroide

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

Kanishkas5301
Asteroide
Spoiler
Capture.PNG