community Alteryx IO Alteryx.com
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
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

chetty
8 - Asteroid
‎08-14-2019 11:06 PM

My solution attached, haven't checked the rest of the comments in the thread however the "since June 2013" part threw me off (in my mind that would usually mean Month>=6 however in order to match the output file provided I had to change this to Month>6)

challenge_8_SC.yxmd
Reply
0 Likes
Bluemoon
8 - Asteroid
‎08-19-2019 06:31 AM

Done!

Spoiler
clipboard_image_0.png
Reply
0 Likes
Joe_Beaven
7 - Meteor
‎08-19-2019 11:32 AM

Done!

Spoiler
#8.PNG
Challenge 8.yxmd
Reply
0 Likes
gwiz
8 - Asteroid
‎08-19-2019 11:57 PM
 
challenge_8_my_solution.yxmd
Reply
0 Likes
Inactive User
Not applicable
‎08-20-2019 02:37 AM

clipboard_image_0.png

challenge_8_solution_LD.yxmd
Reply
0 Likes
Roman_Kornelly
7 - Meteor
‎08-20-2019 12:42 PM

Adding my solution.

MySolution.yxmd
Reply
0 Likes
ecarter-93
8 - Asteroid
‎08-21-2019 08:21 AM

Challenge 8 complete!

 

Week 8 solution.PNG

Spoiler
 
Reply
0 Likes
Zuza
8 - Asteroid
‎08-23-2019 01:11 AM
 
challenge_8_Solution.yxzp
Reply
0 Likes
Inactive User
Not applicable
‎08-23-2019 04:36 AM

good use of secondary table and cross tab.

challenge_8_solution.yxzp
Reply
0 Likes
PaulN
Alteryx Alumni (Retired)
‎08-23-2019 05:36 AM
 
challenge_8.yxzp
Reply
0 Likes
curated machine learning resources