Open In App

Tableau – Operators

Improve
Improve
Like Article
Like
Save
Share
Report

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 Multiplication 4*5=20

(Forward slash)

Numeric Division 50/5=10

(Percentage sign)

A reminder of the numeric division 25/2=1

(Caret)

Raised to the power 5^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.

AND TRUE FALSE
TRUE TRUE FALSE
FALSE FALSE FALSE

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

OR TRUE FALSE
TRUE TRUE TRUE
FALSE TRUE FALSE

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

NOT TRUE FALSE
NOT FALSE TRUE

Last Updated : 26 Nov, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads