filters mainly used restrict the data from database.. filters are three types 1)normal filter- the end user con't change the value dynamically during run time. 2)quick filter- the end user con't change the value dynamically during run time. 3)context filter- context filer is performance based only .suppose we add some fields to context filter ..first execute adding fields only..then it will go to another filters...
Breaking BI Adventures in Business Intelligence
Tuesday, January 29, 2013
Types of Filters in Tableau In Tableau, there are three types of filters. More explicitly, there are three different ways to limit the data that is displayed by your graph. These types are Custom SQL "Filters", Context Filters, and Traditional Filters. Each of these has its own strengths and weaknesses, and we will look at them one at a time.
First, a Custom SQL "Filter" is a WHERE clause that is placed in the SQL that queries the data to be used in the workbook. "Filter" is a Tableau term that technically applies only to Context and Traditional Filters; however, the Custom SQL "Filter" emulates the behavior of a global Context Filter, so we will refer to it as such. By construction, Custom SQL "Filters" are always global. The most common reason for using a Custom SQL "Filter" is to limit the size of a data extract. The smaller your data extract, the more quickly your charts will load. In other words, you can make more complex charts without sacrificing efficiency.
One of the ways to create a Custom SQL "Filter" is during the Server Connection process. For example, here I create a new SQL Server Connection.
SQL Server Connection Once I select the Server and Database I would like to use, I can select the table(s). I can use either the Single Table or Multiple Tables feature to select the table, then I can click on the Custom SQL button.
Custom SQL Server Connection In the SQL code, I can place a WHERE clause to filter on any values I would like. This is the most efficient of all filters. If you would like to place a static, global filter on your data, this is where you should do it.
Next, a Context Filter is a filter in Tableau that affects the data that is transferred to each individual worksheet. Context Filters are great when you want to limit the data seen by the worksheet. When a worksheet queries the data source, it creates a temporary, flat table that is uses to compute the chart. This temporary table includes all values that are not filtered out by either the Custom SQL or the Context Filter. Just like with Custom SQL "Filters", your goal is to make this temporary table as small as possible.
Context Filters have a few advantages over Traditional Filters. First, they execute more quickly than Traditional Filters. They are also executed before Traditional Filters and can be executed all at once, which further improves efficiency. However, they do have one drawback. It takes time for the filter to be placed into context. A rule of thumb, from Tableau's KnowledgeBase, is to only place a filter into context if it reduces the data by at least 10%.
A Context Filter is created by dragging a field onto the "Filters" Shelf and editing the filter. Then, you can Right-Click the field on the shelf and select "Add to Context." If you have multiple context filters, you can CTRL-Select them all and add them to context in a batch. This will improve the efficiency of your filter.
Lastly, a Traditional Filter is exactly what most people think of when they think of filters. When Tableau is creating the visualization, it will check to see if a value is filtered out by a Traditional Filter. Since this is not performed at the table level, it is the slowest of all filter types. However, it does have the advantage of being performed after the Context Filters. This is a necessity if you are dealing with complex "Top N" filters. A Traditional Filter can be created by simply dragging a field onto the "Filters" Shelf.
EDIT: If you would like to know more about the order in which Traditional Filters are processed. Check out this link submitted by Jonathan Drummey:
(Jonathan's Google+) https://plus.google.com/114523841892404322313
I hope you found this post to be informative. Thanks for reading.
Brad Llewellyn Associate Consultant Mariner, LLC firstname.lastname@example.org http://www.linkedin.com/pub/brad-llewellyn/4a/80a/73b/ Posted by Brad Llewellyn at 8:54 AM Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest
Jonathan DrummeyJanuary 29, 2013 at 3:46 PM Hi Brad,
Thanks for adding to the Tableau blogosphere!
I think you're oversimplifying what you're calling "Traditional Filters." Filters that are on calculated fields depend on what level the calculation is processed at - row-level, aggregate, or table calc, and are applied at different times - row-level in the query, aggregates are processed in the query and inside Tableau (and at different times depending on whether the calc is based on a data blend or not), and table calc filters are applied inside Tableau after most all other computations are complete. This post on the Tableau forums is still the best summary out there of the order of filter application: http://community.tableausoftware.com/message/139603#139603.
AnonymousAp ril 22, 2013 at 1:45 PM I appreciate the tips, the existence of context filters is very important when working with large data sets, but (as a new user) it's not terribly obvious that they exist, let alone the difference in how they're applied. Thank you!
AnonymousAugust 28, 2013 at 9:43 AM What about data source filters, and user filters? Two other important filters in Tableau.
Brad LlewellynAugust 28, 2013 at 1:40 PM This blog was one of my first and was written by a much less informed version of myself. I'd like to go back at some point and write a more complete version. Thanks for posting!
Load more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Profile Picture
Profile Picture About Me
I just started a new job, so I'll update this section soon! Brad is an active blogger at breaking-bi.blogspot.com. You can connect with Brad on LinkedIn at http://www.linkedin.com/in/bradllewellyn.
Formatting Individual Columns in Tableau (Dual-Axis Crosstabs) Today, we will look at a special type of graph in Tableau, the "Dual-Axis Crosstab." The inspiration for this method comes from C...
Using the LOOKUP() function in Tableau Today, we will talk about the LOOKUP() function in Tableau. The LOOKUP() function allows you to find values that exist elsewhere in your t...
Tableau vs. Power Pivot Part 1: Basic Functionality Today, we will begin a new series comparing two of the top self-service BI tools on the market, Tableau and Power Pivot. Most people would ... Previous Blog Entries
► 2014 (42) ▼ 2013 (63) ► December (4) ► November (4) ► October (4) ► September (4) ► August (2) ► July (2) ► June (3) ► May (2) ► April (5) ► March (6) ► February (9) ▼ January (18) More Uses for Sets in Tableau Basic Coloring in Tableau Issues Publishing Workbooks to Tableau Server Ways to Improve Performance in Tableau Basic Dashboard Formatting in Tableau Types of Filters in Tableau Different Types of Graphs in Tableau Working with Quick Filters in Tableau Working with Pages in Tableau Working with Parameters in Tableau Sorting your Data in Tableau Working with Filters in Tableau Working with Sets in Tableau Custom Calculations in Tableau Table Calculations in Tableau Filter Actions (Linking) and Highlight Actions (Br... Creating Dashboards in Tableau First Days with Mariner Simple template. Powered by Blogger.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!