05 Dec Tableau – Conditional Filters
Conditional filters in Tableau allow you to filter data based on conditions or criteria that you specify. These filters enable you to narrow down your data to specific subsets that meet certain conditions. Apply conditions to already created filters with the condition filter.
Conditional Filters Operators in Tableau
The following are the operators in conditional filters:
- Equals (=): Filter data where the value equals a specified value.
- Not Equals (≠): Filter data where the value does not equal a specified value.
- Greater Than (>)*: Filter data where the value is greater than a specified value.
- Less Than (<): Filter data where the value is less than a specified value.
- Between: Filter data where the value falls within a specified range.
- In/Not In: Filter data where the value is present or not present in a specified list.
Let us see an example to find the sub-category of products across all segments whose sales are above 50, 000 i.e. 50k.
Let us create a new sheet and name it as Condition Filters. First, drag the Dimension Segment and Measure Sales to the Columns shelf.
After that, drag the Dimension Sub-Category to the Rows shelf. Horizontal bar chart gets created:
Now, drag the dimension Sub-Category to the Filters pane. After dragging, the Filter [Sub-Category] windows open as shown below:
Go to the Condition tab on the Filter [Sub-Category] window.
Select the option By field and click the drop-down.
Set the condition to >= and the value 50000 because we want the sub-category of products across all segments whose sales are above 50,000 i.e. 50k.
Keep the rest, Profit and Sales dropdown as it is, and click OK:
We have set the condition filter above. As you can see, we can also set the range of values. After clicking OK, we get a chart with only a sub-category of products that have the required number of sales:
If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.
For Videos, Join Our YouTube Channel: Join Now
Read More:
No Comments