2 Replies Latest reply on Dec 19, 2016 6:46 AM by Lip-Min Khor

# Product attach rate

Hi,

I am a newbie using Tableau and was having a hard time finding a good solution to this problem. I am trying to work out a sensible attach rate of product B to product A. Here is what I am trying to get to

 Question Data set In any quarter of the year what are the attach rate for noodle and coffee to cake? Company Product Quarter Year How many times coffee is bought with cake How many times noodle is bought with cake A cake 1 2015 0 - as no noodle bought A coffee 1 2015 1 A snack 1 2015 A cake 2 2015 0 - as no noodle bought A coffee 2 2015 1 A snack 2 2015 B cake 3 2015 0 - as no noodle bought B coffee 3 2015 1 B snack 3 2015 B coffee 4 2015 0 - as no cake bought in this quarter C cake 4 2015 C noodle 4 2015 0 - as no coffee bought with cake 1 Total = 3 Total = 1 Attachrate = 3/4 (coffee attach rate to cake) Attachrate = 1/4 (noodle attach rate to cake)

Please can you help advise how I can come up with the calcultion on the right and whether this is already embedded functions in Tableau somewhere to derive this from the dataset on the left?

Thanks

Lip-Min

• ###### 1. Re: Product attach rate

Hi Lip,

Find my approach based on  Market Basket Analysis as reference below explained here and stored in attached workbook version 9.3

• ###### 2. Re: Product attach rate

Hi Norbert,

Sorry for the late reply and many thanks for your help on this, it took me quite awhile to replicate what you have done on the raw dataset that I have, this fits in quite well with what I needed. The only thing is that I think it would be more useful if the data is based on percentile of total itemA pirchase. I notice this relates to support and confidence level, however I couldn't find/get my head around how to achieve this. Some pointers would be greately appreaciated. Many thanks again for your help.

Thanks

Lip-Min