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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #8: Aggregate Consumer Purchases

Asteroid

Hi! Here my solution :)

Alteryx Partner
 
Alteryx Partner

Here's my solution!

Alteryx Partner

My solution :

Alteryx Partner

There it is. I did it. As an Alteryx beginner I struggled a bit, but got it done. I was  bit worried halfway through, as I wasn't sure if one were to assume that soup/salads should also be seen as sides. Luckily I didn't assume, and followed the brief on face value and got the correct result.

Highlighted
Alteryx Partner

Lookup Table for food categorization and order flag--> Join based on new result --> parse and filter date --> Sum total meals --> sum meals flagged with food, drink, and side --> sum the tickets meeting criteria --> join results on record position --> total meals / flagged meals

 

image.png

Asteroid

Here is my solution

Asteroid

My Solution:

 

Spoiler
challenge_8_solution_SP.JPG
Asteroid

Interesting... I thought this should have been smooth sailing, but ended up getting quite different numbers. Looking forward to seeing what others have done, as always!

Asteroid

Ah I see - I did June inclusive... Also made an error including pre-June data in my total and percentage of fields. But that there is why these challenges are helpful!