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

Derangedvisions
11 - Bolide

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
ChuyVBabs
8 - Asteroid

Altered state.

justinjohnson02
7 - Meteor
Spoiler
justinjohnson02_0-1579537601512.png
mikeprice17
8 - 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. 

Ronald_Do
7 - 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

 

GaurVitul
7 - Meteor
 
meeravijayan2011
8 - Asteroid
Spoiler
8.png
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1580311458759.png
AryCardoso
8 - Asteroid
 
BreShawna
5 - Atom

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.