Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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

jstokes1994
7 - Meteor

Solution: 

 

Spoiler
jstokes1994_0-1574863907351.png
danicahui
8 - Asteroid
Spoiler
Challenge 8 2019-11-28.jpg
tiffany_chen
8 - Asteroid

New learn of one solution which is using cross tab to realize count the records matching specific requirement.

Spoiler
2019-11-29_104428.png
ozdogand
8 - Asteroid

late to the party, but here you go..

Spoiler
ozdogand_0-1575332144649.png
jackdaniels
8 - Asteroid
Spoiler
Capture.PNG
CallieYuan
8 - Asteroid

One step at a time

Junya_Wang
8 - Asteroid

This is my first time to participate the challenge.  Critiques are welcome!

 

StephaneP
Alteryx Alumni (Retired)
Spoiler
Done ! 🙂
Stéphane Portier
Sales Engineer
Alteryx
Tisaac95
8 - Asteroid
Spoiler
Spoiler
Ivyin702
7 - Meteor
Spoiler
challenge 8.PNG

Please find the attached solution file