Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

SarikaFrancis
7 - Meteor

SarikaFrancis_0-1675388181978.png

 

T-McGough
8 - Asteroid
Spoiler
Screenshot_20230203_081822.png
gaoa
11 - Bolide
Spoiler
gaoa_0-1675645064990.png

 

MartinNiedziejko
6 - Meteoroid

Challenge complete

akorte1
8 - Asteroid

Done

CeliaC_Silje
8 - Asteroid

 

Spoiler
hycheungal_0-1675764614843.png

A nice challenge

 

Schild959
5 - Atom

Attaching file for challenge. Interesting challenge learnt a lot however didn't explore more at improving just yet.

HardikJani
8 - Asteroid

Hi...very interesting challenge. I used a rather long approach I first looked up the data sheets using and find and replace and filtered it with the date(since June confused me as well) after that I concatenated the orders for each Ticket I'd and filtered unique tickets. I used a filter tool to filter out potential meal. And then used formula tool to get the final result. It was incredible to see the easier logics applied by others something that I would use in future challenges probably 

richmondbound
8 - Asteroid

Always fun doing these. I learned the actual operation of Contains() formula which was giving me for no reason a lot of trouble. I also find it interesting so the different ways this can be completed. I do think though that when it says since June 2013 it should be clarified to say since July 1, 2013. I read it as June 1, 2013 and ended up with a different answer. I didint want to open the full solution workflow and ended up spinning my wheels for too long to try and resolve what was not a flow issue but a clarificaiton issue.

 

In the future I think the terminology should be as specific as possible since we arent in a client meeting with the ability to get explicit answers in situations like these

jdunleap
7 - Meteor
Spoiler
Solution
Weekly Challenge 8 Solution.png