Last Modified Date: 09 Nov 2023
Environment
Tableau DesktopAnswer
Option 1:
Use a calculation similar to the following to count how many times the substring occurs in any value of the dimension [String].
COUNT(IF CONTAINS([String],"substring") THEN 1 END)
Or alternatively
SUM(INT(CONTAINS([String],"substring")))Option 2:
Use a calculation similar to the following to count occurrences of a string value within a dimension:
COUNT
(IF CONTAINS([DIMENSION],'VALUE') == TRUE THEN [DIMENSION]
END) Additional Information
String FunctionsString Calculations
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials