Further Formulas in Tableau
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Logical Functions in Tableau
Logical Functions in Tableau
Logical functions are incredibly useful for building custom categorizations in Tableau. In this lesson, we learn how to use IF/ELSEIF functionality to allocate each customer a Small / Medium / Large designation.
Using Fixed in Logical Functions
Using Fixed in Logical Functions
When logical functions are combined with filters, errors can often occur. To fix this, we can use the FIXED() function to keep our calculation constant, despite the presence of Quick Filters.
AND() and OR() Functions in Tableau
AND() and OR() Functions in Tableau
When setting multiple conditions in a logical function, we use either the AND() function or OR() function to do so. We will learn how both of these functions work in this lesson.
CASE() Function
CASE() Function
The CASE() function is a sometimes a better alternative to IF/ELSEIF when dealing with discrete sets of data. We will learn how to use the CASE() function in this lesson.
Dealing with Null Values
Dealing with Null Values
In most data sets, Null values will often appear in certain columns. In this lesson, we will learn how to deal with Null values in Tableau, using the ZN() function to fix some calculations.
Introduction to Tableau Date Functions
Introduction to Tableau Date Functions
In this lesson, we learn how to use some of Tableau's most popular date functions, DATEPART(), DATETRUNC() and DATEDIFF.
More Date Functions in Tableau
More Date Functions in Tableau
In this second lesson on dates in Tableau, we examine DATEADD(), TODAY() and a couple of other popular functions that will help you manipulation time-series data.
Searching for Text in Tableau
Searching for Text in Tableau
Like Excel, Tableau has many similar functions for searching text strings. In this lesson, we will learn how to use CONTAINS(), STARTSWITH(), FIND() and much more.
Cleaning Address Data
Cleaning Address Data
Address data often causes the most difficulties for users manipulating text. In this lesson, we will learn how to join and split address data using a number of different Tableau functions.
Removing Whitespace from Strings of Text
Removing Whitespace from Strings of Text
Whitespace are spaces that occur either side of a text string. Tableau has a number of functions we can use to remove whitespace, which we will use in this lesson.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
