
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using Like Operator In Set Analysis
Hello,
I am trying to use the like operator in set analysis, I have a comment field and I want to count the different comments like
=count(DISTINCT {<InteractionName={'Uncontactable','Uncontactable closed'},Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}>} Reference)
PFA.
Accepted Solutions
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use double quotes in set analysis to perform a search, so instead of
Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}
use
Comment={"*Uncontacted*","*Wrong Party*","*Invalid Number*","*Fax Number*"}
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use double quotes in set analysis to perform a search, so instead of
Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}
use
Comment={"*Uncontacted*","*Wrong Party*","*Invalid Number*","*Fax Number*"}
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For what it's worth, more on set analysis quoting and examples on:
And the always-learn-something-new from our beloved HIC

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much for the insight Miguel.
