community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #8: Aggregate Consumer Purchases

Asteroid

My solution attached, haven't checked the rest of the comments in the thread however the "since June 2013" part threw me off (in my mind that would usually mean Month>=6 however in order to match the output file provided I had to change this to Month>6)

Asteroid

Done!

Spoiler
clipboard_image_0.png
Meteor

Done!

Spoiler
#8.PNG
Asteroid
 
Inactive User
Not applicable

clipboard_image_0.png

Alteryx Certified Partner

Adding my solution.

Meteor

Challenge 8 complete!

 

Week 8 solution.PNG

Spoiler
 
Asteroid
 
Meteor

good use of secondary table and cross tab.

Moderator
Moderator