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__

__Tableau Operators Types__

Let us see each operator in detail in the below section.

__1. Tableau Arithmetic Operators__

__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__

__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__

__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__

__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__

__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 |