cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Welcome to Alteryx Academy! We hope you enjoy the journey. Let us know how we can improve your learning experience by completing this survey.
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.

Challenge #8: Aggregate Consumer Purchases

Highlighted
raj_k
Meteoroid

Please tell me if this solution looks accurate

LordNeilLord
Alteryx Partner
Spoiler
Weekly Challenge 8.png
KOBoyle
Alteryx Partner

Solution attached.  Since the string values for the Date sorted chronologically, I did not bother parsing.  I didn't think to branch the logic to calculate the total tickets separately from the potential meal deals.  That approach seems unnecessary.

 

Ken

A_Twa
Asteroid

My approach was very similar to others (and different from the posted solution) - looking at the solution file gives me additional ideas for consolidation/optimization of processes going forward.  Thanks!

MsBindy
Asteroid

I thought I was using an awful lot of tools to get to the answer.  Glad to see that my solution is in the ballpark :)

robcarroll
Alteryx Partner

Thanks

sagarb
Meteor

Used two new tools in here, Append Fields and Count Records.

nick_ceneviva
Alteryx Certified Partner

Solution Attached

ADerbak
Meteor

I probably did way too many tools, but I got the solution!

 

See attached.

Hi, this is my first challenge, I tried to keep the workflow as simple as possible