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:
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:
| Operator | Description | Example | Return |
| = | Equal | ‘Naukri’ = ‘Naukri’ ‘Naukri’ = ‘naukri’ |
True False |
| < >, != | Not Equal | 4.0 != 4 | False |
| < | Less than | 2 < 4 | True |
| < = | Less than or equal | 2 <= 4 | False |
| > | Greater than | 2 > 4 | False |
| > = | Greater than or equal | 4 >= 2 | True |
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
| PRECEDENCE | OPERATOR |
| 1 | – (negate) |
| 2 | ^ (power) |
| 3 | *, /, % |
| 4 | +, – |
| 5 | ==, >, <, >=, <=, != |
| 6 | NOT |
| 7 | AND |
| 8 | OR |
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.
Read Later
Data Analyst Interview Questions Data Science Interview Questions Machine Learning Applications Big Data vs Machine Learning Data Scientist vs Data Analyst How to Become a Data Analyst Data Science vs. Big Data vs. Data Analytics What is Data Science What is a Data Scientist What is Data Analyst
Top Picks & New Arrivals
