Logical Functions | Logic Statements in Tableau

1. Objective

In this tableau tutorial, we are going to study about Tableau Logical functions, the different logic statements with examples that we can perform in Tableau.
So, let us start tableau Logical Functions.

Tableau Logical Functions | Logical statements

Logical Functions | Logic Statements in Tableau

2. Tableau Logical Functions

An operator could be an image that tells the compiler to perform specific mathematical or logical manipulations. Tableau encompasses a variety of operators accustomed produce calculated fields and formulas.
Read about Tableau Paged Workbook & Steps to Create it
Following area unit the main points of the operators that area unit obtainable and therefore the order (precedence) of operations.
The basics logical statements in tableau are as follows:

a. CASE Statement

CASE expression once value1 THEN return1 once value2 THEN return2 … ELSE default come back finish
The CASE statement is employed to perform a logical check and come back values supported the result. CASE operates are often rewritten as AN IF function, however, the CASE Logical functions are usually times less complicated to jot down and shorter.
Here’s AN example of a formula:

Tableau CASE Statement - Logical Functions

Tableau CASE Statement – Logical Functions

This CASE statement creates a replacement field by exploring the country field. Once the worth “United States” is found, it uses “USA.” once “United Kingdom” is found, it uses “UK.” All alternative values receive the worth “World.”
Let’s revise Adding Worksheets And Renaming Worksheet In Tableau

b. IF Statement

IF check THEN worth finish / IF check THEN worth ELSE else finish
Tableau IF statement creates a logical check. IF check is true THEN do y. The check a part of the operations should be a mathematician, either by employing a mathematician field within the knowledge supply or because of the results of AN expression victimization operators or logical comparisons (AND, OR, NOT).
Here’s AN example:

Tableau IF Statement - Logical Functions

Tableau IF Statement – Logical Functions

IF test1 THEN value1 ELSEIF test2 THEN value2 ELSE else finish
You can expand the practicality of the IF logical functions with the ELSEIF by adding extra IF-THEN statements. for instance, here we will recreate our CASE formula on top of victimization AN IF-THEN-ELSEIF statement:

Tableau IF Statement - Logical Statement

Tableau IF Statement – Logical Statement

Same result as our CASE operate, grouping all alternative values into World and abbreviated the USA and United Kingdom of Great Britain and Northern Ireland.

c. IFNULL Statement

IFNULL(expression1, expression2)
The IFNULL statement primarily runs a true/false check on whether or not the worth within the tested field is NULL. The primary worth within the operate is employed if the worth isn’t null, and also the second is employed if it’s null.

Tableau IFNULL Statement - Logical Functions

Tableau IFNULL Statement – Logical Functions

If any country’s Total Population doesn’t have a price, then it’ll be reset as zero and removing the null from the fresh created field.
Let’s watch Tableau Data Extract – How to do Data Extraction in Tableau

d. IIF Statment

IIF(test, then, else, [unknown])
The IIF statement is extremely just like the IF operate on top of. It primarily creates a shorthand operate for AN IF-THEN-ELSE statement with the additional advantage of being to outline a price with the ultimate argument if the check yields AN unknown result. Remember, a bit like the IF operate, the check should be mathematician by knowledge kind or lead to a mathematician worth as a results of the check.
Let’s take a glance at AN example:

Tableau IFF Statement - Logical Functions

Tableau IFF Statement – Logical Functions

If the sphere take advantage of modification is a smaller amount than five-hitter then my formula on top of can come back a price of Poor, otherwise it’ll come back sensible.

e. ISDATE Statement

ISDATE(string)
The ISDATE statement tests whether or not the string argument are often born-again to a legitimate date (TRUE) or if it cannot (FALSE). Here’s AN example:

ISDATE Statement - Logical Functions

ISDATE Statement – Logical Functions

The on top of a formula is approved by Tableau as a result of the sphere that we have a tendency to used is so a string knowledge kind, however, each result can clearly be FALSE. you would possibly use this logical functions. If your date is formatted in an exceeding vogue you would possibly not acknowledge, like ISO 8601. Here’s AN example:

ISDATE Logical Functions

ISDATE Logical Functions

The on top of worth represents Sept one, 2014 and so may be a valid worth for a date.
Learn Tableau Save, Reorder and Delete Worksheet

f. ISNULL Statement

ISNULL(expression)
Another straightforward statement, ISNULL, merely tests whether or not AN expression is null (TRUE) or not (FALSE).

ISNULL Statement - Logical Functions

ISNULL Statement – Logical Functions

If you wish to filter null values from your image, you’ll be able to filter null values with the Filter card.

g. ZN Statement

ZN(expression)
The last logical Functions are that the atomic number 30 operate. It’s a variation on the ISNULL and IFNULL operate. Atomic number 30 tests to ascertain if a operate is null, and if it’s, it’ll come back a price of zero.

ZN Statement - Logical Functions

ZN Statement – Logical Functions

The first time you see a listing of logical functions, there’s the inevitable hesitation on what all of this suggests. Currently that we’ve suffered all, hopefully, you’ll notice them helpful in investing your knowledge and your image even over before. If you wish to leap in and learn a lot of regarding once to use these functions, here’s a good post.
Let’s Discuss Tableau Highlight Table – Steps to Build Highlight Table

3. Conclusion

In this tutorial, we studied the different logical functions: CASE Statement, IF Statement, IFNULL Statement, IIF Statment, ISDATE Statement, ISNULL Statement, ZN Statement in a tableau with examples, and how we can use Logical statements in tableau to perform various operations. With this, we complete yet another milestone in our journey. Furthermore, if you have any query, feel free to ask in a comment section.
See Also- Tableau Bubble Chart & How to Create Tableau Heat Map
For reference

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.