Tableau Filters

Filter  is a fundamental piece of breaking down data.Filter activities are an approach to send data between worksheets. Usually a filter action is utilized to send data from a chose mark to another sheet indicating related data. For instance, when looking at a view demonstrating the sales price of houses, you might need to have the capacity to choose a specific house and demonstrate every single equivalent house in an alternate view. You could characterize a channel activity to finish this task.  First you need to choose what equivalent means. For this situation, say that equivalent houses will be houses with a comparative deal cost and area. A channel activity to indicate practically identical houses can be characterized by choosing a goal worksheet and characterizing channels on deals sales storage and square Footage.

Get in touch with OnlineITGuru for mastering the Tableau Online Course 

Filter Dimensions :

These filters are applied on the measurement fields. Normal illustrations include separating in view of classifications of text or numeric values with greater or less than con articulations more prominent than or not as much as conditions.

Example:   

We utilize the Sample – Superstore information source to apply dimension Filters  on the sub-class of products. We make a view for demonstrating benefit for each sub-classification of items as indicated by their delivery mode. For it, drag the dimension field “Sub-Category” to the Rows shelf and the measure field profit  to the Columns shelf.

Tableau/Tableau Online Tutorial/OnlineITGuru

Next, drag the Sub-Category dimensions to the Filters rack to open the Filter dialog box. Tap the None button at the base of the rundown to deselect all fragments. At that point, select the Exclude alternative in the lower right corner of the dialogues box. At last, select Labels and Storage and after that click  OK.

Data/Tableau Online Tutorial/OnlineITGuru

Filter Measures :

 These Filters are applied on the measure fields. Filtering depends on the calculations applied to the measure fields. Subsequently, while in dimension Filters you utilize just  values  to Filter, in measures channel you utilize values in light of fields.

Example :

You can utilize the Sample – Superstore information source to apply dimension filters on the average value of profits. To begin with, make a view with transport mode and subcategory as measurements and Average of benefit as appeared in the Following screenshot.

AVG/Tableau Online Tutorial/OnlineITGuru

Next, drag the AVG (benefit) value to the filter pane. Pick Average as the channel mode. Next, chooses”At least” and give an values to channel , which meet these criteria.

Avg Profit/Tableau Online Tutorial/OnlineITGuru

Filter Dates :

Tableau treats the date field in three different ways while applying the date field. It can apply filter by taking a relative date when compared to today.  Each of this alternative is introduced when a date field is dragged out of the filter pane.

Example:

We pick the example – Superstore information source and make a view with order date in the column shelf  and benefit in the rows shelf  as appeared in the  following screenshot.

Filter Dates/Tableau Online Tutorial/OnlineITGuru

Next, drag the “order date” field to the filter shelf and pick Range of dates in the filter dialog  box. Pick the dates as appeared in the following screenshot.

Quick Filters :

Many filter types in Tableau are rapidly accessible utilizing the right-click alternative on the dimension or measure. These channels known as Quick channels have enough usefulness to understand the greater part of the common filtering needs.

Quick Filters/Tableau Online Tutorial/OnlineITGuru

Filter Order Dates/Tableau Online Tutorial/OnlineITGuru

Example :  Consider the Sample-Superstore data source to apply some quick filters. In the below

example ,  pick sub-classification as the  row  and sales as the column which  by default  delivers a horizontal bar chart. Next, drag the sub-class field to the filter pane . All the subcategories show up by the graph. Apply wild card filtering  separating utilizing the expression a* which chooses all subcategory name beginning with “a”.

Pick Sub-Categery/Tableau Online Tutorial/OnlineITGuru

Condition filters :

One of the vital filtering alternatives in Tableau is to apply a few conditions to officially existing channels. These conditions can be extremely straightforward like finding just those sales which are higher than a specific sum or it can be a complex one in light of a specific equation. The conditions can likewise be connected to make a range filter.

Creating conditional Filter :

Utilizing the Sample-superstore, how about we find that sub-class of products over all portions whose deals surpass one million. To accomplish this target, following are the steps.

Step -1 : Drag the measurement fragment and the measure Sales to the Column shelf. Next, drag the dimension Sub-Category to the Rows shelf. Pick the flat bar chat alternative. You will get the accompanying graph.

Creating Conditional Filter/Tableau Online Tutorial/OnlineITGuru

Step – 2 : Drag the measurement Sub-Category to the Filters Shelf. Right-click to alter and go to the tab Condition. Here, pick the radio alternative by field. Starting from the drop down, select Sales, Sum and more prominent than equivalent to image determining the value 100000.

Read more about Tableau  in this overview Tableau tutorial now!

Filter Sub-Category/Tableau Online Tutorial/OnlineITGuru

On completion of the over two stages, we get an outline which indicates just those subcategory of items, which have the required amount of sale. Likewise this is appeared for all the accessible sections where the condition is met.

Tableau/Tableau Online Tutorial/OnlineITGuru

Drop Us A Query

Trending Courses
  • Python and Django Online Training
  • Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.

  • Tableau Online Training
  • Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.

  • MicroStrategy Online Training
  • Micro Strategy is one of the few independent and publicly trading Business Intelligence software provider in the market. The firm is operational in 27 Countries around the globe.

  • PEGA (PRPC) 7.2 Certification Online Training
  • Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).

  • Workday Online Training
  • Workday specialises in providing Human Capital Management, Financial Management and payroll in online domain.It is a major web based ERP software vendor.

  • Power BI Online Training
  • Power BI is business analytics service by Microsoft. With Power BI, end users can develop reports and dashboards without depending on IT staff or Database Administrator.


100% Secure Payments. All major credit & debit cards accepted.