We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #88: Counting Combinations

vishalgupta
7 - Meteor

Summarize tool did the trick

BenMoss
ACE Emeritus
ACE Emeritus

Taking a look at everyone elses it looks like a took an extra step for no reason, there was logic in my mind to doing so at the time, but there no longer is! 

Spoiler
workflow.png

 

Ben

AndyJK
5 - Atom

Thinking about the question "What other tweaks can you think of that might make this Challenge relevant for other tasks?"

Analytic app that allows you to select some or all Items. Returns all distinct combinations of any of the selected items, with a count of transactions.
Leave as default (everything selected) and calculates all combinations, as per the other solutions
Could extend further by:
1) Giving option of only combinations that contain only ALL selected items (e.g. "apples AND milk" instead of "apples AND/OR milk")

2) Joining back to the original data to get the full list of purchases where the selected combination is involved.

Joe_Mako
12 - Quasar

Why stop at just a count of combinations? This data like this is an opportunity to experiment with Market Basket tools in Alteryx (MB Affinity, MB Rules, and MB Inspect tools in the Predictive Grouping category). I only wish there was more data or real data to see an actual trend.

 

Spoiler
c88.png

 

Natasha
9 - Comet

My solution

 

Spoiler
I recently enjoy using Unique tool, but seems there was no need in it this time.Screen Shot 2017-10-03 at 21.19.44.png
EmanueleE
8 - Asteroid

My solution!!!

Spoiler
I didn't use a Summarize to concatenate, but I sorted them and use the unique tool
#WC88-EE.PNG

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

Hi @ChristineB,

 

Great interactive training kudos to you.

 

After solving this I checked @jdunkerley79's solve and was pleased that we were IDENTICAL.  Then I checked @patrick_digan's and thought that his was very creative and elaborative, not to mention that he solved it multiple ways.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
M-Shedid
5 - Atom

Second Challenge :)  Building the habit

Have a great week everyone

data_rachel
8 - Asteroid
Spoiler
challenge88.PNG
Inactive User
Not applicable

Second challenge, second week! It ended up being easier than I initially thought. I also made a second solution that uses the unique tool. Had never used that before!