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

ganeshnaicker
7 - Meteor
‎06-14-2018 08:43 AM

My answer is not same as solution provided. I have included June data so my solution is different but the methodology should solve it

challenge_8_solution - Ganesh.yxmd
Reply
kcoulon
8 - Asteroid
‎06-14-2018 03:10 PM

Challenge Completed!

challenge_8_solution.yxmd
Reply
0 Likes
justynam
8 - Asteroid
‎06-15-2018 07:11 AM

My solution :-)

challenge_8_solution_JM.yxmd
Reply
0 Likes
cmarchese
7 - Meteor
‎06-15-2018 03:57 PM

As some others mentioned in the comments below, I too was counting tickets starting 6/1/2013. after reading comments adjusted my filter to 7/1/2013. Good use of crosstab on this one. Spoiler alert!

challenge_8_my_solution.yxmd
Reply
0 Likes
Inactive User
Not applicable
‎06-16-2018 10:30 AM
 
challenge_8_solution_file.yxmd
Reply
0 Likes
soha-elghany
8 - Asteroid
‎06-17-2018 05:00 AM
Spoiler
spoilerchallenge 8.png
challenge_8_start_file.yxmd
Reply
0 Likes
mjholland
7 - Meteor
‎06-17-2018 06:16 PM

Getting there …

 

Spoiler
Challenge #8 My Solution.PNG

Challenge #8 My Solution.yxmd
Reply
0 Likes
CharlieS
17 - Castor
17 - Castor
‎06-18-2018 02:12 PM
 
Challenge_0008-CharlieS_Solution.yxmd
Reply
0 Likes
Robert2
7 - Meteor
‎06-20-2018 06:57 PM

Solution

Challenge 8.yxmd
Reply
kvnpt
7 - Meteor
‎06-24-2018 07:38 AM

I used extra formulas instead of a secondary lookup table.

KP Weekly Challenge 8 Solution.yxmd
Reply
0 Likes
curated machine learning resources