Challenge #88: Counting Combinations
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator