ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

hugolees
7 - Meteor
Spoiler
2018-12-21_10-21-37.png
OliverW
Alteryx Alumni (Retired)

My Solution

 

grafik.png

 

 

 

bradley_slaughter
8 - Asteroid

 

 

catarina_pimpao
8 - Asteroid

Nice challenge. 

 

Spoiler
AWC_08.JPG
KatyP
7 - Meteor

My solution. Thanks!

CamodCPA
8 - Asteroid

This is fascinating to read through because of all the different approaches talent! I too ended with slightly different numbers.

 

Spoiler
startfile7.PNG
Flippe
7 - Meteor

I thought the same thing...Since June 2013, for me, reads as "since the first of June 2013"

Flippe
7 - Meteor

I tried a longer path but I liked the original solution better. I'll keep the mindset for the next challenges. 

Sajeel_Kershi
8 - Asteroid

was getting higher percentage until i put an OR condition then matched the output. Technically if Burger and Pizza and Drink and Side ordered  then I would have thought that would be counted as a Potential Meal Deal. To Match required Output, changed logic so that either ([Burger] + [Drink] + [Side]) OR ([Pizza] + [Drink] + [Side] flags ticket as a Potential Meal Deal

mbonora
7 - Meteor

My answer.