Tableau Operators- Arithmetic, Relational & Logical Operators

In this Tableau tutorial, we are going to study about Tableau Operators with types: Arithmetic Operators, Relational Operators, Logical Operators with examples.

What are Operators

An image that is utilized to impart the compiler to play out certain scientific or consistent controls is an Operator. Various administrators are offered by Tableau to make recipes and computed fields.

Types of Tableau Operators

There are 3 basic operators in tableau:

• Arithmetic Operators
• Relational Operators
• Logical Operators

a. Arithmetic Operators in Tableau

The Arithmetic administrators can be utilized to make articulations on numbers and date information compose segments.

• Addition       –       +
• Subtraction  –       –
• Multiply       –       *
• Divide         –        /
• Modulation  –        %
• Power         –        ^

Note: The Arithmetic Tableau Operators can be used in any clause of a SQL statement, except the from clause.

b. Relational Operators in Tableau

A comparison operator is a binary operator that takes two operands whose values are being compared. Comparison operators are used in conditional statements, especially in loops, where the result of the comparison decides whether execution should proceed. They form the key to program flow control, known as conditional processing.

• Equality Operator                         –      =
• Not Equality Operator                   –     < >,  !=, ^=
• Greater Than Operator                  –     >
• Less Than Operator                       –     <
• Greater Than Equal to Operator      –     >=
• Less Than Equal to Operator          –      <=

Example:

• Select Ename, Sal, Job From Emp Where Job = ’SALES MANAGER’;
• Select Ename, Hiredate, Deptno, Sal From Emp where Deptno < > 10;
• Select Empno, Ename, Sal From Emp where Sal >= 3000;
• Select Ename name, Sal basic, Sal * 12 Annual From Emp where sal * 12 > 60000;

c. Tableau Logical Operators

Logical operators contain only three commands.
a. Logical conjunction operator “AND”
b. Logical disjunction operator “ OR”
c. Logical negation operator “NOT”

i. Conditions satisfy “AND” Operators

1. It Returns TRUE if both or all component conditions are TRUE.

2. It Returns FALSE if either is FALSE, else returns unknown.

ii. Conditions satisfy “OR” Operators

1. It Returns TRUE if either of the component conditions is TRUE.

2. It Returns FALSE if both are FALSE, else returns unknown.

iii. Conditions satisfy “NOT” Operators

1. It Returns TRUE if the following condition is FALSE.

2. It Returns FALSE if the following condition is TRUE.

3. If the condition is unknown, it returns unknown.

Related Topics – Tableau Field Operations & Tableau Data Blending 

Conclusion

In this tutorial, we learned about different types of Tableau operators – Arithmetic Operators, Relational Operators, Logical Operators with examples. This will help us work with Tableau better and do our work more efficiently. If you have any query, feel free to ask in comment section.