We have worked to understand the order of operations in Tableau at a high level.

Actually there are also filtering operations at a lower level. Here we are going to have a look into the order of operations within either of dimension filter and set filter.

A good understanding of the filtering options will let us take advantage of the versatile functionalities of the dimension and set filters. Especially, the filters within are not affected by dimensions in view. Otherwise, equivalent individual filters may require more sophisticate setups, such as advanced table calculations.

1. Dimension Filter
For every dimension, when placed in the filter shelf, right click it and select the 'Filter' option, you will see this interface with 4 tabs: General, Wildcard, Condition, Top.
These are actually 4 filters that you can set up to filter this dimension. Believe it or not, from left to right, this is the order of operations for these 4 filters. I figure this out by trial and error.
Official document regarding dimension filters can be found here.

2. Set Filter
Creating a set is a way to define a subset of a dimension. Three filters can be defined when creating the set. Two filters can be defined after the set is placed in the filter shelf. There could be as many as 5 filters to be defined within a set filter.

2.1 Filters in creating a set
When creating a set, you are presented with this interface:
Note there are 3 tabs: General | Condition | Top. Each tab is a filter definition.

Thus there are 3 filters in creating a set. The order of operations is from left to right.

2.2 Filters after placing the set in filter shelf
When placing a set in the filter shelf, we can configure two more filters.
2.3 The order of operations within set filters
Again, the order of operations is from left to right. In total, we can define as many as 5 filters in cascade within a set filter.
3. Minor Filter Descriptions (subcategories of filters)
Inside both dimension and set filters, there are 4 minor types of filters: General, Wildcard, Condition, Top. Each filter will further narrow the scope of the data set. Below are brief descriptions of the filters.
3.1 General filter
There are 3 options in a general filter: Select from list | Custom value list | Use all

It is a filter by checking on/off a list of dimension members. Here is an article on using custom value list.
3.2 Wildcard filter
This filter is string-search based on the name of the dimension members.
3.3 Condition filter
This is a measure filter, using one or more measures as conditions.
3.4 Top filter
This is a rank filter, which is a special table calculation filter. Using this one can avoid setting up sophisticated advanced table calculations when using a standalone rank filter.
4.Conclusion
By understanding the order of operations of the dimension and set filters, we can create filters in a compact way, instead of creating individual calculated fields as filter or setting up advanced table calculations. Here is a workbook comparing various ways of implementing the same filter.

Note that set filter has precedence over dimension filter, and set filter is basically a special dimension filter, we may have as many as 5+4=9 filtering options for any particular dimension.

The diagrams for the above order of operations are drawn in Tableau and can be downloaded here.

0

Add a comment

(Refresh the page if you want to view the gif image multiple times. Or go to Tableau Public and click the button at the top-right corner.)

Jake and I collaborated on a dashboard. He told me that he learnt a way to create an in-place help page in Tableau. He first saw it at a conference somewhere and couldn't recall who the speaker was. So I am blogging here about it but the credit goes to somebody else. If anyone knows who the original creator is, leave a comment below.

The key idea is to float a semi transparent worksheet on top of the dashboard, where a help text box is strategically placed on top of each chart. This way, we can explain how to view each chart and what data points are important, etc. This worksheet is collapsible by a show/hide button. 

Below I would like to show how this worksheet can be constructed.

1. Sheet with a single data mark.

  • Double click the empty space in Marks panel and add two single quotes. Make the null pill a text label. This creates a single null mark.
  • Set the view as "Entire View"

2. Create an show/hide button

  • Go to the target dashboard
  • Drag a floating vertical container to the dashboard, making it cover all the area of interest.
  • Drag the Single Null Mark sheet and drop it into the above container. Hide the sheet title.
  • Create an open/close button for the container and place the button at the top-right corner.

3. Add annotations

  • Format the sheet background opacity as 70% in the layout manager             
  • Select area annotations and place them anywhere of interest. 
  • Write help text and format it to highlight important messages.  
  • The text can serve as functional guide and/or insight guide.

Here is an example. Feel free to download the workbook and explore. Click the "i" button at the top-right corner to view the in-place help. 

0

Add a comment

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.