Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

qb
7 - Meteor

Baby's second challenge response. This was helpful cross-tab practice.
I don't like that I've filtered the dates by string, or how ugly the meal filter is, but I need to accept that sometimes "done" is better than "perfect". I'll learn better with time!

 

challenge-8.PNG

David-Carnes
12 - Quasar

Pretty standard fare.

 

Spoiler
008.png
alexo
8 - Asteroid

I used a formula to generate flags for each meal type, then a summarize max (read: boolean AND), grouping by ticket id to find the ones that matched all three conditions.

pengland17
6 - Meteoroid

Hello!

 

Please find attached my solution to the challenge.

 

Spoiler
SolutionChallenge 8 Screenshot.JPG

Many thanks,

 

Paul

ExploreMore
8 - Asteroid

My solution

RotesDB
8 - Asteroid
Spoiler
Challenge#8.png
ocasey
6 - Meteoroid

Not the most direct way but only two extra steps!

LukeG
Alteryx Alumni (Retired)
Spoiler
Challenge_8_LG.PNG

My Solution. I used the Contains() function to identify whether a row had (Pizza OR Burger) AND (Side AND Drink)

Cbarker
6 - Meteoroid

Just completed weekly Challenge #

Spoiler
Weekly Challenge #8 Screenshot.PNG

eric_strein
8 - Asteroid

Solution attached.