In this article we will show you, How create Condition / Conditional filters in Tableau with example. Before getting into this, Please refer Tableau Filters to understand the basic filtering techniques. For this demo,we are going to use the data source that we created in our previous article. Please visit Data Labels in Tableau Reports article to understand the Data Source.
Conditional Filters in Tableau
First, Drag and Drop the English Product Name from Dimension Region to Rows Shelf, and Sales Amount Measures region to Columns Shelf. By default, tableau will generate the Bar Chart as shown below.
In this example, we are going to add filter condition on English Product Name. First, Please click on the down arrow beside the Product Name present in the Row Shelf will open the menu as shown below. Here, you have to select the Filter.. option.
Once you select the Filter.. option, a new window is opened to create filter.
By Field option in Conditional Filters
Following are the list of options available in this section:
First Drop down List: By default this will select the Measure value present in the record. But you can change the filed by clicking the down arrow. When you click that down arrow, it display all the Measures, and Dimensions present in the data source.
Second Drop down List: By default this will select the Aggregate Function that is applied on the Measure value. But you can change the function by clicking the down arrow. When you click that down arrow, it display the list of functions available for that Measures.
Third Drop down List: By default this will select the = operator. But you can change the operator by clicking the down arrow. When you click that down arrow, it display the list of assignment operators that are available.
Load: When you click on this button, Filter window will load the Minimum and Maximum values into their respective text box fields. This wil help you to understand the data.
From the below screenshot you can observe that, we are selecting the By filed section. Next, we selected the Sales Amount as the condition, Sum as the Aggregate function, and used the >= operator. And lastly, we added 1,000,000 value in the text box.
Below report is displaying all the records whose Sum of Sales Amount is greater than or equal to 1,000,000.
Here you can write your own custom, and more complex conditions as the Filter condition.
While you type any letter in that Text filed, Tableau intelligence will display the list of available options such as: Filed Name, and function names.
From the below screenshot you can observe that, we are selecting the By formula section. Next, we added SUM([SalesAmount]) >= 1000000 code
Following report is displaying all the records whose Sum of Sales Amount is greater than or equal to 1,000,000.
Thank You for Visiting Our Blog