Hello together,
I am trying to do a market basket analysis.
Therefore, I used the MB Rule- & MB Inspect tool. The workflows works just fine.
However, the "Lift" KPI is calculated incorrectly.
From testing with a small sample size I think I figured out that Alteryx gives out the "Support" of the LHS item/item bundle as the "Lift" of the whole LHS & RHS-rule (see red marker).
If I calculate "Lift" manually as [Support productbundle AB] / ([support product A] * [support product B]), I do get different results than Alteryx. E.g. for Egg -> Salt, Lift should be 2. However, Alteryx gives out 0,5 as the corresponding Lift (just the same as the support value..., see yellow marker).
I am desperatly trying to find my/the error. Can someone help me? Find my simple testing workflow and the input-Excel attached.
Thanks in advance!
Best regards,
Daniel
