How to create a «Does Not Contain» Filter on Einstein Analytics / Tableau CRM

There are use cases that require a type of filter that’s not available out of the box today in Einstein Analytics. That’s the “does not contain” filter.

Before we begin, I am assuming you are familiar with Data Modeling, Multi Value fields, Dataflows and bit of Bindings.

Let’s start with the dataset. That’s the key here. Not SAQL. Dataset and Dataflow, data modeling basically.

I will use the Accounts and Opportunities from a Dev Org. This is how the initial Dataflow looks:

Basic stuff here so far. Load Opptys and Accounts, then augment Opptys using the Account ID as a “Look Up Single Value”. I have selected just Account Name and Billing State from the Account for this example.

These are my output fields:

Here is the JSON: