1 Reply Latest reply on Oct 26, 2016 3:19 PM by Yuriy Fal

    Group on several values/rows of a single dimension

    Pierre-Marie Airiau

      Hi,

       

      I would like to know if something is do-able in Tableau, and if so, how ?

       

      I have a dataset that look like this :

       

      Id |  component

      1  |       c01      

      1  |       c03      

      2  |       c01      

      1  |       c02      

      3  |       c05      

      2  |       c02      

      3  |       c01      

      1  |       c03      

      2  |       c02      

      2  |       c04      

      4  |       c01      

      3  |       c04      

      3  |       c02      

      2  |      c01      

      4  |       c05      

      3  |       c02      

      4  |       c03    

      4  |       c02      

       

      And I would like to group rows on couples of "component" 's values.

      For exemple, make a COUNTD(Id) for each component couple :

       

      component_val1 | component_val2 | COUNTD(Id)

              c01             |          c02             |          4          (1, 2, 3 and 4)

              c01             |          c03             |          2          (1 and 4)

              c01             |          c04             |          2          (2 and 3)

              c01             |          c05             |          2          (3 and 4)

              c02             |          c03             |          2          (1 and 4)

              c02             |          c04             |          2          (2 and 3)

              c02             |          c05             |          2          (3 and 4)

              c03             |          c04             |          0

              c03             |          c05             |          1          (4)

              c04             |          c05             |          1          (3)

       

      So, to summarize, I would like to realise aggregation on couples (or more) values of a single dimension, a do calculation on it.

       

      If someone know a way (without changing the data-source model) to perform this in Tableau, that would be a great help. Thanks !

       

      PM