The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
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

jaialai32
7 - Meteor

Here's mine.

cc000072
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_8.JPG
taraspringate
6 - Meteoroid

My solution:

Chirag09goa
7 - Meteor

Solved

veronicawei1021
6 - Meteoroid

This is my solution. I used Filter, Unique and Join several times. 

Milanz
9 - Comet

High,

Spoiler
Unbenannt.JPG

My original WF didn't fit to the given output.

My calculation is only 15375, not 15497 as the total number of ticket IDs.

And the reason is (found out after a sleepless night 😉 )that I calculated only IDs which show:

            pizza OR burger AND (side AND drink)

 There are 122 Ticket IDs without any Main Dish. 

My WF shows following options:

- one solution that fits the output, 

- a solution where all ticket IDs show a meal

- prove of missing meals

From my point of view this was not an easy beginner challenge !!!

But.... FUN!

BR Michael

Brad4Data
Alteryx Alumni (Retired)

Here is my solution.

 

SeanAdams
17 - Castor
17 - Castor

Resubmitting with a second python solution 

 

Spoiler
AlteryxSolution.pngPythonSolution1.pngPythonSolution2.pngPythonSolution3.pngPythonSolution4.png


#SnakingMyWayThruChallenges
Lucatelli
8 - Asteroid

Please find attached my proposed solution.

cody_rush
7 - Meteor
Spoiler
cody_rush_0-1587678562413.png