This content has been marked as final. Show 3 replies
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.