
1. Re: Correlation Matrix Between Two Different Dimensions
Diego Parker Jan 27, 2019 2:51 AM (in response to Stephen Groff)1 of 1 people found this helpfulHey Stephen,
By any chance, could you share your workbook or a mockup of your data as that way would be easier to understand. Also, the calculation you uploaded works with what is displayed in your worksheet, so by itself does not provide much information.
Best,
Diego

2. Re: Correlation Matrix Between Two Different Dimensions
Stephen Groff Jan 27, 2019 9:13 AM (in response to Diego Parker)Hi Diego,
I've attached the workbook that I'm referencing.
I also setup sheet1 just as all the tutorials had said to do... but again, this only allows me to so show a correlation between a single dimension (actually the same one twice per the table it's being pulled from).
I'm beginning to think that in order to compare two different dimensions, I don't need to do a Cartesian Product type of join... I can simply use the Pearson Correlation Coefficient to compare a single table using two different dimensions.... nonetheless, I still have no idea how.

Pearson1.twbx 7.4 MB


3. Re: Correlation Matrix Between Two Different Dimensions
Shinichiro Murakami Jan 27, 2019 10:07 AM (in response to Stephen Groff)I am not sure you really seeking "correlation" in this case o not.
I mean I cannot understand which two measure you want to get correlation.
Above simply shows the defect ratio by Area x Model.
You can filter by family or whatever you want.
Thanks,
Shin

Pearson1_SM_10.5.twbx 7.6 MB
