The goal is to return matches of phrases (more than 2 of the same word I guess) by each of these rows, with what the phrase is and how many instances it occurs.
For example:
Google Ad 1 | Google Ad 2 |
and the Descr Line 1 has 3 of the same words, then:
| Instances | Clicks | Spend |
Be Found In | 15 | 500 | $500 |
More Online Searches | 20 | 450 | $750 |
Hi Erik,
One way to do this would be to search for the specific terms in the field and then do a count of them. So for example a calculated field similar to the following would be created:
if contains([Descr Line 1], "Be Found In")=true then count([Descr Line 1]) end
Hope this helps!
-Tracy
Become a Viz Whiz on the Forums! Support the Community and master Tableau.