3 Replies Latest reply on Aug 20, 2018 5:29 AM by Jasim Ansari

    Calculating fraction share of common attribute values present across various attributes

    Jasim Ansari

      I am just a day old in Tableau, still learning a lot of new wonderful features of it. Right now, I have this task which I would like to finish it off at earliest.

       

      I would like to calculate percentage share of the total number of common values present across various attributes.

       

      For example, I have a data like this:

      Value
      Type1Type2Type3
      A010501
      B020104
      C01Null03
      D060501
      E050601

       

      I would like to display the Type attribute values of only these types- 01, 02, 05, 06 as a fraction share per Value attribute.
      That is:

      Value01020506
      A2/61/3
      B 1/61/1
      C1/6
      D1/61/31/2
      E1/61/31/2

       

       

       

       

      Thank you