Loading

Counting Occurrences of a String Within a Dimension

Дата публикации: Apr 30, 2025
Задача
How to count the number of times a particular text string occurs within a dimension.
Действия

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) 
Дополнительные ресурсы
String Functions
String Calculations
Номер статьи базы знаний

001458221

 
Загрузка
Salesforce Help | Article