Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #8: Aggregate Consumer Purchases

Highlighted
Meteor

My Solution

Highlighted
Alteryx Certified Partner
 
Highlighted
Meteor

Seems a bit clunky to use filter tools, but it worked.

 

 

Highlighted
Asteroid

Solution attached.

Highlighted
Meteoroid

Was struggling with difference of total between given solution and my solution..later found that the date was used wrongly and was considered from July and not June.

 

Attaching the simplified solution that uses only "FindReplace", "Filter" and "summarize" tools.

Highlighted
Asteroid
 
Highlighted
Bolide

Nice and simple challenge.

Spoiler
My solution :

Challenge8.jpg
Highlighted
Meteor
 
Highlighted
Meteor
 

Here is my take on the Challenge # 8.