topic Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128211#M34804 <P>Hi @upuc</P> <P>Did @martin_mueller's arules command suggestion not solve your issue? Didn't hear from you for a month.</P> Mon, 20 Oct 2014 03:52:39 GMT ppablo 2014-10-20T03:52:39Z How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128204#M34797 <P>I would like to search for common product-packages. So I want to look for one item (AAA) and find out which other item (XXX) was bought most often in the same purchase order (Orders with AAA).<BR /> I already clicked through the other questions on this page and found the following link:</P> <P><A href="http://docs.splunk.com/Documentation/Splunk/5.0.4/SearchReference/Correlate">http://docs.splunk.com/Documentation/Splunk/5.0.4/SearchReference/Correlate</A></P> <P>Sadly, I'm not able to apply this query to my problem. Hope someone can help.<BR /> Best regards</P> Wed, 17 Sep 2014 10:18:03 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128204#M34797 upuc 2014-09-17T10:18:03Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128205#M34798 <P>A sample of event data would be very useful here. Is it the case that each line item in an order is a separate Splunk event? Or are they clumped together somehow, with all line items for an order in the same event?</P> Wed, 17 Sep 2014 12:44:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128205#M34798 aweitzman 2014-09-17T12:44:45Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128206#M34799 <P>According to the docs at <A href="http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/Arules">http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/Arules</A> you're looking for the <CODE>arules</CODE> command.</P> Wed, 17 Sep 2014 12:57:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128206#M34799 martin_mueller 2014-09-17T12:57:07Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128207#M34800 <P>Let me know if and how that works though, I've always been wondering...</P> Wed, 17 Sep 2014 14:54:49 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128207#M34800 martin_mueller 2014-09-17T14:54:49Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128208#M34801 <P>Hi @upuc</P> <P>Did the arules command that @martin_mueller suggested below work for your use case?</P> Mon, 22 Sep 2014 22:57:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128208#M34801 ppablo 2014-09-22T22:57:19Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128209#M34802 <P>we save every item as a seperate event with a code for the underlying shopping cart.</P> Tue, 23 Sep 2014 06:41:12 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128209#M34802 upuc 2014-09-23T06:41:12Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128210#M34803 <P>Hello helpers!<BR /> Still no solution in sight. If maybe ppablo or martin found a way to handle this by now (?) it would be great if you could share.</P> Thu, 16 Oct 2014 09:37:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128210#M34803 upuc 2014-10-16T09:37:56Z Re: How to search for the most popular purchased item X AND which other item was purchased most often with item X? https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128211#M34804 <P>Hi @upuc</P> <P>Did @martin_mueller's arules command suggestion not solve your issue? Didn't hear from you for a month.</P> Mon, 20 Oct 2014 03:52:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-for-the-most-popular-purchased-item-X-AND-which/m-p/128211#M34804 ppablo 2014-10-20T03:52:39Z