3 Replies Latest reply on Apr 23, 2018 8:42 AM by Tim Dines

    Count number of appearances of a value in a field that contains delimited values

    Andrew Glendening

      New Tableau user here: I have a column that has multiple values separated by column. I would like to count the number of times a value appears in that column.

       

      This question is exactly the question that was posed here: https://community.tableau.com/thread/208970

       

      Unfortunately, the assumed answer in the previous thread is not possible for me. I am not able to reshape the data outside of Tableau.

       

      Here is the original question's scenario:

       

      Example Data:

      Country

      US
      US; Canada
      US
      US; Mexico; Canada
      [Blank]
      Mexico
      ...

       

      What I'm getting

      Country

      Count

      US2
      US; Canada1
      US; Mexico; Canada1
      Mexico1
      ......

       

      Desired Output

      Country

      Count

      US4
      Canada2
      Mexico2
      ......

       

      I appreciate any help you can give me. Thanks!

       

      -Andrew