Hi,
I have two vizzes (viz's?) each usingthe same two fields:
1. [ad names] (unique, string)
The names use a naming structure similar to the following (CampaignTitle_Placement_AdSize_AdType_CreativeID)
2. [ad values] (int)
Each viz has two filters:
1. Country (single value dropdown)
2. Search box (using a calculated field and parameter)
Filters to match the user entered free text
I would like to add a third filter:
3. Exclude Box
Displays all records but the user entered free text
The end goal is to have a dash with these two visualizations side-by-side so users can search for an ad in each and compare them side-by-side. So far so good, it works and looks snazzy, but I can't look at a single ad in viz A and look at all, minus the one, in viz B.
Viz A: Shows only CampaignTitle_Placement_AdSize_AdType_001
Viz B: Shows all ads EXCEPT CampaignTitle_Placement_AdSize_AdType_001
I have tried
NOT CONTAINS([ad names] , [search Parameter])
then checking TRUE in the filter
and I tried
CONTAINS([ad names] , [search Parameter])
then checking FALSE in the filter
No luck
If both text boxes are blank then nothing shows.
I can get one or the other to work but not both.
Any thoughts?
When I need a different type of filter on the same field I typically just make a copy of that field and filter on that.
Sure, if they contradict each other then you'll never get results however if used properly (i.e. only one is actually filled out) then it's all good.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.