From the course: Advanced Tableau Desktop

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Contextual joins: Removed

Contextual joins: Removed - Tableau Tutorial

From the course: Advanced Tableau Desktop

Start my 1-month free trial Buy for my team

Contextual joins: Removed

“

- [Instructor] Removed is the final contextual join rule that we'll be talking about. This rule states that you can use the count field from any table that you want to remove nulls from. All you need to do is choose a value greater than one to remove the nulls without removing all nulls. In the last example, we didn't want to remove all of the neighborhoods, even though the home stores were null. But the removed rule can essentially help us remove null measures from our table without removing all nulls from the view. In the example below, we've taken the count of Sales by Store field and we've applied the greater than one rule. This will remove any null values that we had in our Quantity Sold field. Looking at the relationships leveraged in the view, we can see that we have both the store lookup for store type and neighborhood joined to two separate measures. The first is our Quantity Sold, which is in Sales by Store, but we also have our count field coming from Sales by Store. The…

Contents