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

chrisrayner
8 - Asteroid

As ever, not overly elegant, but it works

WegmanJordy
7 - Meteor

Hereby the solution.

mollyhatch
8 - Asteroid

 

Another great challenge!

 

Spoiler
Solution Image.PNG

 

 

Igor_Garlowski
7 - Meteor

Thanks for the challenge

 

One part that was confusing is the date "tickets since June 2013" in my opinion this includes all June, your solution doesn't.

Marleen23
7 - Meteor

My solution

 

Spoiler
Marleen23_0-1581417483806.png
Blake
12 - Quasar
Spoiler
Blake_0-1581445460786.png
ZLavasque
6 - Meteoroid
Spoiler
ZLavasque_0-1581571820111.png

 

Not elegant and I am sure that I could reduce the number of formula tools I use, but it works.

AdrienGohy
8 - Asteroid

Here is the final file.

 

I don't get the same result as in the solution file because in the thread it asks after July 2013, but in the exercice file it asks after June 2013.

dark_a
7 - Meteor

Here is my solution.

 

I think it is more accurate to calculate how much Meal deals potentially can be purchased vs Total Main courses was purchased. So I added my opinion too.

avinashsunchu
8 - Asteroid
Spoiler
Solution.JPG