3 Replies Latest reply on Mar 29, 2018 12:48 PM by Tyler McDonald

    How to Create Text Chart with patterned summations in each row/column? Tableau v10.4

    Tyler McDonald

      Currently I'm trying to create a text chart that has a patterned summation in order to display the rows and columns. An example of what I mean:

      Data:

         

      Col1Col2Col3
      AAB
      AAB
      BAB
      CBB
      ABB
      CCB
      CCB
      BCB
      BCC

       

      What I want Tableau to display:

       

      Col1Col2Col3
      A330
      B328
      C341

       

       

      So in this case, every columns has a list of 3 possible options (A,B, or C). I want to take the number of "A"s in each column and put them in the "A" cell pertaining to each column. Same thing for "B"s and "C"s. Any help would be greatly appreciated!

       

      Another thing as well, after creating the text chart, I would like to put a final row that lists the percentage of "A"s divided by the Number of Records. Expanded Example:

       

      Col1Col2Col3
      A330
      B328
      C341
      % A33%33%0%

       

      If you don't know how to do that, a solution to just the first part of my questions would still be great! Thanks.

       

      (Note: The attached .twbx file is empty except that it's connected to the test data I listed in the beginning of this question)