Tableau Operators: Arithmetic, Comparison and Logical

In this article we will discuss different operators in Tableau like arithmetic, comparison and logical operators.

Introduction

In this article, we will discuss operators in Tableau.

In computer programming operators are the symbols that are used to perform specific mathematical or logical manipulations.

In Tableau, we mainly have 3 types of operators let’s discuss them briefly

Table of Content:

• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Order Precedence

Arithmetic Operators:

An arithmetic operator is a mathematical function that takes two operands and performs calculations on them.

The basic arithmetic operations are addition (+), subtraction (-), multiplication (*), division (/), modulo (%), power (^).

• Addition (+)

When the + operator is applied, it means:

• addition when applied to numbers
  • Eg: 5 + 5 = 10
• Concatenation when applied to the string
  • ‘abc’ + ‘def’ = ‘abcdef’
• Add number of days to a date, when applied to dates
  • #April 4, 2022# + 6 = #April 10, 2022# 

• Subtraction (-)

When the – operator is applied, it means:

• Subtraction when applied to a number
  • 5 – 4  = 1
• Negation when applied to an expression
  • – (5+5) = -10
• subtract the number of days to a date, when applied to dates
  • #April 4, 2022# – 2 = #April 2, 2022# 
  • #April 4, 2022# – #April 2, 2022#  = 2

• Multiplication (*)

When the * operator is applied, it means numeric multiplication.

• 5 * 4 = 20
• 9 * 9 = 81

• Division (/)

When the / operator is applied, it means numeric division.

• 5 / 2 = 2.5
• 20 / 2 = 10

• Modulo (%)

The modulo operator % returns the remainder in the division.

• 7 % 2 = 1
• 35 % 5 = 0

• Power (^)

The power operator ^ means, raised a number to a specific power.

• 2^3 = 8
• 5^4 = 625

Comparison Operator

Comparison operators are used for the comparison of expression. Operators are used two compare numbers, dates, strings, and return a boolean.

Some of the comparison operators are:

Logical Operators

Logical operators have only 3 operators: AND, OR, NOT.

• AND Operator
  • It returns TRUE only if both the conditions are TRUE
  • It returns FALSE if either one or both the conditions are FALSE

• OR Operator
  • It returns FALSE only if both the conditions are FALSE
  • It returns TRUE if either one or both the conditions are TRUE
• NOT Operator
  • It returns TRUE if the following condition is FALSE
  • It returns FALSE if the following condition is TRUE

Order Precedence

Conclusion

In this article, we have discussed operators in Tableau: Arithmetic, logical and comparison operators.

Hope this article will help you in your data analyst journey.

This article is a part of a complete tutorial of Tableau, focusing on Tableau certified data analysts and tableau desktop specialists. 

Through a series of articles, we will cover all the topics in-depth with examples.