Skip to content
Related Articles

Related Articles

Improve Article

Tableau – Operators

  • Last Updated : 26 Nov, 2020

Tableau is the easy-to-use Business Intelligence tool used in data visualization. Its unique feature is, to allow data real-time collaboration and data blending, etc. Through Tableau, users can connect databases, files, and other big data sources and can create a shareable dashboard through them. Tableau is mainly used by researchers, professionals, and government organizations for data analysis and visualization.

In this article, we are going to discuss Tableau Operators and types of Tableau operators. 

The symbols which tell the compiler to execute specific mathematical or logical manipulations are known as Operators. Tableau too has a good number of operators, which help in the formation of calculated fields and formulas.

Tableau has 4 basic types of Operators as mentioned below:

  • General Tableau Operators
  • Arithmetic Tableau Operators
  • Relational Tableau Operators
  • Logical Tableau Operators

GENERAL TABLEAU OPERATORS –



The operator which we generally use in mathematics computation comes under this category, like Addition and Subtraction. 

  • Addition:    +
  • Subtraction:    –

General Operator

Description 

Example 

+

(Addition)

It can perform multiple operations like adding numbers, concatenating strings, and adding days to dates.

2+3=5, 

#May 15, 2014# + 17 = #June 1, 2014#



 —

(Subtraction)

It can also perform multiple operations like subtracting numbers and subtracting days from dates.

8-5=3, 

#July 16, 2000# — 10 = #July 6, 2000#

ARITHMETIC TABLEAU OPERATORS – 

The operators which help to perform arithmetic calculations on different fields of uploaded data source are known as Arithmetic operators. 

  • Multiply:    *
  • Divide:    /
  • Modulation:   %
  • Power:   ^

Arithmetic Operator

Description

Example



(Asterisk)

Numeric Multiplication4*5=20

(Forward slash)

Numeric Division50/5=10

(Percentage sign)

A reminder of the numeric division25/2=1

(Caret)

Raised to the power5^2=25

RELATIONAL TABLEAU OPERATORS – 

A relational operator or comparison operator is a binary operator that takes two operands as input, compare their values and returns the output. A comparison operator is generally used in conditional statements, loops, where the comparison result will decide, whether execution should go ahead or not.  

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

Relational Operator



Description

Example

>

Greater than

5>8 

= False

>=

Greater than or equal to

4>=4

= True

<

Less than

4<10

= True

<=

Less than or equal to

1<=0

= False

==

Equal to

8==8

= True

!=

Not equal to

7!=7

= False

LOGICAL TABLEAU OPERATORS – 

In Logical operator, there are three basic commands – 

  • Logical conjunction operator or “AND” operator
  • Logical disjunction operator or “ OR” operator
  • Logical negation operator or “NOT” operator

Logical AND operator: The operator will return True, if both conditions are true. If either condition is false, it will return false else return Null.

ANDTRUEFALSE
TRUETRUEFALSE
FALSEFALSEFALSE

Logical OR operator: The operator will return True, if either of the condition is True, else returns False.

ORTRUEFALSE
TRUETRUETRUE
FALSETRUEFALSE

Logical NOT operator: The operator will return True if condition is False and vice versa.

NOTTRUEFALSE
NOTFALSETRUE
My Personal Notes arrow_drop_up
Recommended Articles
Page :