Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

RichoBsJ
11 - Bolide

Hi! Here my solution :)

AndrewLehm
8 - Asteroid
 
MJG
7 - Meteor

Here's my solution!

sachin02
8 - Asteroid

My solution :

CobusVenter
7 - Meteor

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.

mmccowin
6 - Meteoroid

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

Anastasiia
8 - Asteroid

Here is my solution

sprodger
8 - Asteroid

My Solution:

 

Spoiler
challenge_8_solution_SP.JPG
HuwHallam
8 - 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!

HuwHallam
8 - 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!