11 Replies Latest reply on Dec 3, 2014 8:38 AM by Jonathan Drummey

    Data overlapping

    Rimantas Kuodys

      Hello,

       

      I am new to Tableau and cannot find the appropriate solution for quite some time.

       

      The problem that I am solving - I need to calculate intersection/overlapping of particular attribute.

      For example. For data

      IDAttribute
      1A
      1B
      1A
      1B
      1C
      1D
      1E
      2A
      2A
      2A
      3B
      3C
      3C

       

      I need to calculate how many distinct IDs have Attribute A, B, C (easy part), then A&B, A&C, A&D, A&E, B&C, B&D  etc.

      I can achieve this by using multiple sheets for each attribute. One for A, one for B, etc

      Also, it maybe be possible to achieve transforming data. Neither of these two options are apealing. Thus solution in single sheet would be welcom if this is possible to do with tableau.

       

      Many thanks in advance.