ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

AidanBramel
8 - Asteroid
‎08-14-2018 09:37 AM

Attached are my solutions! My first attempt worked but was a bit clunky with 12 tools, so I started over and got it down to 7 tools. 

 

Spoiler
Challenge 8 Final solution.PNG
challenge_8_solution_1.yxmd
challenge_8_solution_2.yxmd
Reply
0 Likes
Lee_Gibbons
7 - Meteor
‎08-15-2018 08:54 AM

Solution Attached :D

challenge_8_solution.yxzp
Reply
0 Likes
Wouter
8 - Asteroid
‎08-16-2018 03:21 AM

My solution:

Spoiler
challenge 8.jpg
challenge_8_solution_WK.yxmd
Reply
0 Likes
myastarling
11 - Bolide
‎08-16-2018 09:27 AM

My solution is attached.

challenge_8_myastarling.yxmd
Reply
0 Likes
kat
12 - Quasar
‎08-17-2018 02:08 AM
Spoiler
Challenge #8.PNG
Challenge #8.yxmd
Reply
0 Likes
AT_12
7 - Meteor
‎08-19-2018 10:52 AM

Summarize by Type > Get Count
Transpose to get count of Each type
Apply formula to identify Purchase

challenge_8_Solution.yxmd
Reply
EFran
7 - Meteor
‎08-21-2018 09:35 AM
Spoiler
Sol.png
challenge_8_EFran.yxmd
Reply
0 Likes
MattDuncan
7 - Meteor
‎08-22-2018 03:04 AM

Solution attached

challenge_8_Matt Solution.yxmd
Reply
0 Likes
Vinutha
8 - Asteroid
‎08-23-2018 11:34 AM

Crosstab and Summarize tools.

challenge_8_start_file.yxmd
Reply
Inactive User
Not applicable
‎08-24-2018 06:51 AM

Bit of a long way round, but got there eventually!

CE challenge_8_start_file.yxmd
Reply
0 Likes