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
Alteryx Partner

Glad I read some of the comments- i was also selecting the wrong date range (i was initially including June)

Spoiler
DerangedVisions_1-1579466059223.png
Highlighted
Asteroid

Altered state.

Highlighted
Spoiler
justinjohnson02_0-1579537601512.png
Highlighted
Asteroid

I created a boolean field for "Burger or Pizza", "Sides", And "Drinks". If all three were true within a given ticket ID it counted towards total potential meal deals. 

Meteor

Tried to make the answer as slim as I could and used the IsEmpty formula which came in real handy. This one was a good exercise.

 

Spoiler
Ronald_Do_0-1579886488433.pngRonald_Do_1-1579886501135.png

 

Highlighted
Meteor
 
Highlighted
Alteryx Partner
Spoiler
8.png
Highlighted
Spoiler
sonyakasenkramer_0-1580311458759.png
Highlighted
Asteroid
 
Highlighted

Got it figured out! 

Thank you to some of the early comments about how to interpret "since June 2013". Once I had the right date filter, it all worked out.