Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #8: Aggregate Consumer Purchases

Highlighted
7 - Meteor
Spoiler
 
Highlighted
7 - Meteor
Here is my shot at it.
Highlighted
7 - Meteor

Hi , 

 

I took count of tickets where all 3 (Drink, Food or Side) are ordered together and count of all tickets to get percentage where these 3 are purchased together.

 

Thanks1

Highlighted
Alteryx
Alteryx
 
Highlighted
8 - Asteroid

Challenge #8 solved!

 

Spoiler

I didn't get the same answer as in the output until I changed it to July 2013, I think the wording might have been confusing.

clipboard_image_0.png
Highlighted
7 - Meteor

challenge complete!

Spoiler
clipboard_image_1.png

 

Highlighted
Alteryx Certified Partner

Probably not the most optimal solution, but it got the job done eventually

Highlighted
8 - Asteroid

My solution

6 - Meteoroid

Not overly elegant, but a good exercise in the Cross tab tool

Spoiler
clipboard_image_0.png
Highlighted
8 - Asteroid