1. Home
  2. Training Library
  3. Introduction to Tableau | DAL4 RS A3.1 |

Using Conditional Logic to filter data | DAL4 RS A3.1 |

Sometimes, it can be very helpful to reduce the volume of data you are working with by making selections against fields in your data, which state:

IF column = x, then include, ELSE exclude

Here you are testing if the condition is true or false and filtering out the false values. This conditional logic can be applied to any column or value in your data source and is enacted using the Filter menu at the top right corner of the data source connection screen. Through this method you can focus on the data you are particularly interested in and lessen the impact of working with large data sources on your computer too. This is often called ‘reducing the ‘noise’ because the design processes are quieter for you and your laptop.

screenshot showing that the Filter menu option is located in the top right corner of the data source connection screen

|Image: Data source connection screen: Tableau filter menu option |

Let’s view an example of applying a filter on the field Country on retail sales data. This might mean selecting only a small number of specific countries, excluding certain countries, choosing countries according to part of the name, a condition or dynamically picking up the top 5 countries by quantity sold.

Applying a filter on the field Country on retail sales data might mean selecting only a small number of specific countries, excluding certain countries, choosing countries according to part of the name, a condition OR dynamically picking up the top 5 countries by quantity sold, for example.

| Image: Example of applying a filter on a Country field |

There are many other examples of conditional logic in Tableau, such as creating calculations, dynamic filtering, parameters, sets, groups and interactions from one viz to another.

Next, let’s leave the data source connection view aside and turn your attention to the more visual part of Tableau.

 

 

Difficulty
Intermediate
Duration
1h 20m
Students
4
Description

Welcome to the Introduction to Tableau part of the training. Here, you'll learn about the software’s main functionalities, how to create visualisations and filtering as well as publishing options. You will also explore the Tableau Public portal and be introduced to the Tableau Public community as well as learn more about searching content, downloading and interactivity options.

About the Author
Students
23767
Labs
113
Courses
902
Learning Paths
43

A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.