Forum Discussion
Calculate Pairwise Combinations without using Calculated Tables
I have the following data model: Class Category Type Value Class 1 1 T1 2 Class 1 2 T2 3 Class 1 3 T1 1 Class 1 4 T2 5 Class 2 5 T1 9 Class 2 6 T2 17 ...
Hi cassendar987 I think you need to Preprocess the data inorder to achive that use a script (SQL or Python) to generate all pairwise comparisons for each class.Then create a structure where each row represents one comparison with corresponding CategoryType and Value.Then set up a matrix visualisation using the new table