3 Replies Latest reply on Jan 25, 2018 2:41 PM by Zhouyi Zhang

    Counting Occurrences of a String Within a Dimension without specifying individual substring

    Nikunj Dani

      Hi, I have a dimension field coming in as shown in the screenshot below. I'd like to count the number of times a value shows up in my data set. I know one way to do this is by using my unique value in sub-string as shown in the kb (link below). However, is there a way to do this without specifying individual sub-string? I'd like to Tableau to automatically detect unique string and calculate for me.

       

      I have attached the excel file with my sample data that I used to generate this example as well.

       

      I'd appreciate any help. Thanks - Nick.

       

      Counting Occurrences of a String Within a Dimension | Tableau Software

      Tableau Data Transform Requirements.jpg