Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Correlation between products and creation of a heatmap using the correlation matrix

mboroto_89
8 - Asteroid

using the field name "Category Name" i want to establish if there is a correlation between the various products.

This is to help come up with a pearson correlation matrix and then product a heatmap analysis, the heatmap analysis is to help depict closely related products to help with product recommendation.

 

Closely related products(with a high correlation e.g 0.7) are to be recommended.

Attached is the data extract with the dump, main focus is on "Category name"

 

 

 

2 REPLIES 2
gabrielvilella
14 - Magnetar

Is this what you are looking for? You also might want to look at the Market Basket tools.

mboroto_89
8 - Asteroid

Thanks @gabrielvilella this works well, much appreciated!

Labels