In this article, we will learn how to do Conditional Filtering in tableau worksheet to do further operations. For this first look into two terms :
- Tableau: Tableau software is one of the fastest-growing data visualization tools which is currently getting used within the BI industry. It is the simplest thanks to changing or transform the raw set of knowledge into an easily understandable format with zero technical skills and coding knowledge.
- Filtering: Filter a visualization to limit and customize the data displayed on visualization in a dashboard. For example, you can filter the visualization to display only selected geographical regions, the top five most-profitable regions, or those regions with more than $1 million in revenue.
Dataset used in the given examples is Dataset.
For this we have to follow some steps :
Open the Tableau tool and connect a dataset into it. Drag and drop the one sheet of the connected dataset. Click on sheet1 to open the tableau worksheet. On clicking Sheet1 you will get whole dataset attributes on the left side and a worksheet for work.
To apply conditional filtering, prepare a worksheet with some graphs or charts.
By clicking on the filter and then on the condition you will get the window given below :
Here one can apply conditional filter either by using field value with a condition or by applying a formula to the values of one or multiple fields.
- Applying By field:
- Applying By formula: