Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event 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

nikomacaluso1
Meteoro

Done. 

Hi Perhaps my WF is slightly lengthier than the solution shared. I have parse the date field so that data will be in exact date format and will be more simple to filter for the beginners. Plus, I have done multiple filters to choose the Food (Pizza & burger) chosen along with side or a drink instead the flag method.

 

sajithanandcheriyil_0-1651219598407.png

 

MargMo
Meteoro

I realise my original post didn't have the attachment. Here goes!

bold3d
Asteroide

Here is my solution to challenge #8.

millerbp
Asteroide

Consumer purchases aggregated.

JamesCharnley
Pulsar
Saqueador
JamesCharnley_0-1652299213783.png

 

I can remember struggling on this during my first day ever learning Alteryx and never getting the answer. Coming back to it now and getting the answer immediately felt good to say the least!

Hi Perhaps my WF is slightly lengthier than the solution shared. I have parse the date field so that data will be in exact date format and will be more simple to filter for the beginners. Plus, I have done multiple filters to choose the Food (Pizza & burger) chosen along with side or a drink instead the flag method.

 

sajithanandcheriyil_0-1652338489834.png

 

Wanhope
Asteroide

My solution for challenge #8

abristow
Átomo

My solution.  Fun challenge.

cyg3003
Asteroide

workflow is attached. Different way with the provided solution.