MB rules : Error due to minimum value of parameters

Rohit_Karvekar

I am doing Market Basket Analysis using MB rules tool. Seems like minimum value for "support" parameter I can set is 0.002 and that for "confidence" is 0.05. My input data is such that the max "support" is below 0.002 (millions of transactions across thousands of SKUs). This is causing an error. Looking for inputs on handling this case. Is there a way to set "support value well below 0.002?

apathetichell

I can't tell you if it will work or generate the results that you want (I'd recommend getting your MB to run first before lowering the support) but I can answer your question - yes. you can lower the support requirement... Here's how - open the macro which underlies the tool and look for this screen.

choose the numeric dropdown second from the right. Change the minimum value. Save this macro and close it.

Voila.

Again - I'm just answering your question - I have no idea what results you'll get or how long it will take your workflow to run.