Forum Discussion
Correlation between values in table
Hi
I have a table with articles from different producents which fit on different cars
Example:
Part Producer Car
1 a 1
1 a 2
1 a 3
3 b 2
3 b 3
3 b 4
(IE Part 1 from Producent a fits on car 1-2-3, and Part 3 from Producent b fits on car 2-3-4)
Im trying to create a measure which shows the correlation between the Articles on cars in my table, and show the ones with the highest fit
For example the above would show
Part Producer Fit
1 1 (3,b 2/3)
2 Replies
Hi ChristianE ,
Not sure if I understand your expected result. How does a producer get a 1, when the only values are alpha. Is this a count? Also please explain (3,b 2/3).
Thank you,Nathaniel
Sorry after i wrote the example out i changed producers from numbers to letters try to make it more understandable, but it appears i missed the one in the result. It should be:
Part Producer Fit
1 a (3,b 2/3)
Meaning part 1, from producer a, is like part 3 from producer b, in 2 out of 3 cases (where the three is the number of possible fits for part 1). Does that make sense?
