10 Replies Latest reply on Jul 31, 2015 8:29 PM by Koosha G

    How to sum number of similar votes to each item?

    Koosha G

      Hello,

       

      Given a set of items and voters for each item, I am trying to sum the number of times that each two voters voted the same. For example, how many times John and Karen voted the same (yes, no, absent) for each item id. The result of this calculation would be a matrix representing pairwise sum of similar votes (example Tableau file is attached). I am trying to find a way to calculate values in the second worksheet.

       


      Thanks,

      -- Koosha