I need to find records where
Field-A has "string1" OR Field-A has "string2"
Field-B has "string1" OR Field-B has "string2"
Field-C has "string1" OR Field-C has "string2"
I used "Set" to filter but those are "AND" logic and I can't use more than one field in the formula. I would get this error message:
"The formula must be an aggregate calculation or refer to only this field"
A calculation similar to the following should get the desired result:
if contains([FieldA], 'string1') or contains([FieldA], 'string2')
contains([FieldB], 'string1') or contains([FieldB], 'string2')
contains([FieldC], 'string1') or contains([FieldC], 'string2')
else 'filter out'
Hope this helps!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...