0 Replies Latest reply on Mar 19, 2012 5:03 PM by bronwencleary

    Calculate the percentage of data common to two data sets?

      I'm looking for the equivalent to your typical Venn Diagram.  Basically, given two (or more) sets of data, how much data is in common in both sets?

       

      Venn.png

       

      If Set A contains 1, 2, 3 and 4 and Set B contains 3, 4, 5 and 6, then each set has 3 and 4 in common.  Or 50% in common (two data points out of four).

       

      Is there a way to calculate this in Tableau, or at least identify the data that is common to both?