Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Awesomeville
7 - Meteor

My Solution for Challenge #8.

Sophia4310
5 - Atom
 
adityan92
7 - Meteor

Bring it on! 

Loic
Alteryx
Alteryx

my solution. I think it is simpler than some others. I filter first then create 3 flags and aggregate without using any transpose, cross-tab or complicated joins.

kxs
5 - Atom

Second challenge completed!  Took me a while though...  Hopefully with practice I start getting the hang of it. 

mgcarrenard
7 - Meteor

My solution.

pfredin
7 - Meteor

Here is my solution.

jagdeep_singh85
8 - Asteroid

please find my solution in attachment

erick_irigoyen
Alteryx Alumni (Retired)

Attached is my response. My goal was to consolidate all orders by member ID in just one row. To do so, I used the "Summarize" tool and then used the formula tool to calculate the final metrics. 

 

Thanks

TimothyManning
8 - Asteroid
Spoiler
8. Data Analysis.PNG

I like the Data Analysis challenges