1 Reply Latest reply on Aug 3, 2012 9:14 AM by Tracy Rodgers

Identifying, displaying & quantifying like terms in a data set

Erik Ford Aug 1, 2012 7:14 PM

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

1. Re: Identifying, displaying & quantifying like terms in a data set

Tracy Rodgers Aug 3, 2012 9:14 AM (in response to Erik Ford)

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
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Incoming Links

Re: How can I count the number of sequential identical values?

Tableau Community Forums

Identifying, displaying & quantifying like terms in a data set

1. Re: Identifying, displaying & quantifying like terms in a data set

Actions

More Like This

Incoming Links