In this article we will discuss different operators in Tableau like arithmetic, comparison and logical operators.
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:
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 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:
|=||Equal||‘Naukri’ = ‘Naukri’
‘Naukri’ = ‘naukri’
|< >, !=||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 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
|3||*, /, %|
|5||==, >, <, >=, <=, !=|
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.
In this article, we will discuss one of the important concepts...read more
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
Download this article as PDF to read offlineDownload as PDF