Tableau provides basic operators to perform the calculations such as Arithmetic Operation, Logical operation, Relational Operation, and General Operations. We can use these operators to perform the analysis on various types of data to get the value.
The following is the list of Tableau Operators supported by Tableau.
Tableau Operators Types
Let us see each operator in detail in the below section.
1. Tableau Arithmetic Operators
Tableau Arithmetic Operators are used to perform the Arithmetic operation on numeric data. The following is the list of Arithmetic Operators supported in Tableau.
| Operator_Name | Operator_Description | Example |
|---|---|---|
| *(Multiplication) | This operator is used to perform the Numeric multiplication. | 500*20 = 10000 |
| /(Division) | This operator is used to perform the Numeric division | 50/3 = 16.66666 |
| %(modulo) | This operator is used to provide the Reminder of numeric division | 13 % 2 = 1 |
| ^(power) | This operator is used to Raised to the power | 2^4 = 16 |
2. Tableau Relational Operators
Tableau Relational operators are used to perform the comparison of a numeric, character string, or logical data and return the result either true or false that is used in deciding Tableau. Following is the list of Tableau Relational operators.
| Operator_Name | Operator_Description | Example |
|---|---|---|
| = = or = (Equal to) | This operator is used to compare two string/number/date to check equality and return Boolean value TRUE if the values are equal otherwise it will return FALSE. | ‘World’ = ‘Hello World’ 10 = 100/ 5 |
| != or <> (Not equal to) | This operator is used to compare two string/number/date to check none quality and return Boolean value TRUE if the values are equal otherwise it will return FALSE. | ‘Success’ <> ‘Fail’ 45 != 45 / 2 |
| > (Greater than) | This operator is used to compare two string/number/date to check the first argument is greater than second argument and return Boolean value TRUE if it qualifies otherwise it will return FALSE. | [Sales] > 60000 [Category] > ‘W’ [Sales date] > #Oct 19, 1990# |
| < (Less than) | This operator is used to compare two string/number/date to check the first argument is smaller than second argument and return Boolean value TRUE if it qualifies otherwise it will return FALSE. | [Sales] > 60000 [Category] <‘W’ [Sales date] > #Oct 19, 1990# |
3. Tableau Logical Operators
The Tableau Logical Operators are used to perform the logical operations and return the Boolean result TRUE or FALSE. Following is the list of Logical Operators supported in Tableau.
| Operator_Name | Operator_Description | Example |
|---|---|---|
| AND | The AND operator will return TRUE if both expression values are present otherwise it will return FALSE. | [Sales Date] > #Oct 5, 2000# AND [Sales_Profit] > 20000 |
| OR | The OR operator will return TRUE if any of the expression values are present. If expression values are not matching at all then it will return the value FALSE. | [Sales Date] > #Oct 5, 2000# OR [Sales_Profit] > 20000 |
| NOT | This operator is used to ignore the Boolean expression which is presented after it. | NOT [Sales Date] > #Oct 5, 2000# |
4. Tableau General Operators
The General Operators are used to perform the addition of two numbers, the addition of two strings, the addition of two dates, similarly subtraction of two numbers, and so on. The following is the list of general operators supported in Tableau.
| Operator_Name | Operator_Description | Example |
|---|---|---|
| +(Addition) | This operator is used to add two numbers, strings, dates, and so on. | 100 + 400 EmpName + EmpID #Oct 14, 2000# + 14 = #Oct 28, 2000# |
| –(subtraction) | This operator is used to subtract two numbers, subtract the dates, and so on. | 100 + 400 #Oct 14, 2000# - 1 = #Oct 13, 2000# |
5. perator Precedence
The Operator Precedence is used to decide the order in which they are going to evaluate. The same order precedence is evaluated from left to right in the formula also the inner parentheses are evaluated before the outer parentheses.
The following is the list of Tableau Operator Precedence.
| Operator_Precedence | Operator_Name |
|---|---|
| 1 | –(negate) |
| 2 | ^(power) |
| 3 | *, /, % |
| 4 | +, – |
| 5 | ==, >, <, >=, <=, != |
| 6 | NOT |
| 7 | AND |
| 8 | OR |