Filtering is the process of removing specific values from a result set. Tableau filtering feature allows both simple scenarios using field values and advanced calculation or context-based filters.
In Tableau, there are three types of basic filters as follows:
• Filters Dimensions: Filter dimensions are the filters applied to the dimension fields.
• Filters Measures: Filter measures are the filters applied to the measure fields.
• Filter Dates: Filter dates are the filters applied on the date fields.
Filters Dimensions
These filters are applied to the dimension fields only. Below examples include filtering based on categories of numeric values or text values with logical expressions less than, or greater than conditions. In dimension filters, you can use only values to filter.
For example, consider a data source such as Sample – Superstore, to apply dimension filters on the sub-category of products.
We have to create a view for showing profit for each sub-category of products according to their shipping mode.
• Drag the dimension field Sub-Category to the Rows shelf
• And, the measure field profit to the Columns shelf.

• Next, drag the Sub-Category dimension to the Filters shelf to open the Filter dialog box.
• And, click on the None button at the bottom of the list to deselect all segments.
• Then, select the Exclude option in the lower right corner of the dialog box.
• Last, select Labels and Storage and click on OK button. The below screenshot shows the result with the excluded above two categories.

Filters Measures
These filters are applied only on the measure fields. In measures filter, you can use calculations based on fields.
For example, consider a data source such as Sample – Superstore, to apply dimension filters on the average value of the profits.
• Create a view with ship mode and sub-category as dimensions and Average of Profit as shown in the below screenshot:

• Then, drag the profit value to the filter pane. Choose Average as the filter mode and click the Next button.

• After that, choose At least and give value to filter the rows, which meet this criteria and click on OK button.

• After all of the above steps, you get the final view that showing only the sub-categories whose average Profit is greater than 25 in the below screenshot:

Filter Dates
Tableau distributes the date field in three different ways while applying the date field. It can apply filter by taking a relative date as compared to today, a perfect date, or Range of dates. Each of these options presented when a date field is dragged out of the filter pane.
For example, consider a data source such as sample – Superstore and,
• Create a view with Order Date in the column shelf and Profit in the rows shelf as shown in the below screenshot.

• Then, drag the Order Date field to the filter shelf and choose Range of dates in the filter dialog box and click on the Next button.

• After that, choose the dates and click on the OK button as shown in the below screenshot.

• After all of the above steps, you get the final view that showing chosen Range of dates shown in the below screenshot.

So, this brings us to the end of blog. This Tecklearn ‘Basic Filters in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau
• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface
Data Connection with Tableau Desktop
• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online
Basic Visual Analytics
• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets
Advanced Visual Analytics
• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering
Calculations in Tableau
• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations
Level of Detail (LOD’s) Calculations
Advanced Charts in Tableau
• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
Parameters
• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line
Dashboards and Stories
• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points
Data Security in Tableau
Optimizations tips and tricks
Interacting with Tableau Server
Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

588