Tableau Number Functions
Calculations are an integral part of any data analysis. Calculations can be applied to fields in Tableau using the calculation editor. A number of inbuilt functions in Tableau can be used to create expressions for complex calculations. In this tutorial, we are understanding the Number Functions in Tableau.
Number Functions
Number functions in Tableau are designed to manipulate and transform numeric data in various ways. These functions allow users to perform mathematical operations on data, round numbers to specific decimal places, and format numbers with custom symbols, among other things. In this article, we will explore some of the most commonly used number functions in Tableau and how they can be used to enhance data analysis and visualization.
In Tableau, users often need to apply mathematical operations to fields. This is where the number functions, one of the types of Tableau functions, come in handy. The number functions available in Tableau allow users to perform various mathematical operations. Here’s an overview of the number functions in Tableau:
ABS
The ABS function in Tableau is used to return the absolute value of a given numerical value. Its syntax is as follows:
Syntax:
ABS(Numerical Value)Example:
ABS(-15) = 15ACOS
The ACOS function in Tableau is used to return the arc cosine value of a given numerical value. Its results are typically returned in radians. Its syntax is as follows:
Syntax:
ACOS(Numerical Value)Example:
ACOS(0.5) = 1.04719ASIN
The ASIN function in Tableau is used to return the arc sine value of a given numerical value. Its results are typically returned in radians. Its syntax is as follows:
Syntax:
ASIN(Numerical Value)Example:
ASIN(0.5) = 0.5235ATAN
The ATAN function in Tableau is used to return the arc tangent value of a given numerical value. Its results are typically returned in radians. Its syntax is as follows:
Syntax:
ATAN(Numerical Value)Example:
ATAN(180) = 1.565ATAN2
The ATAN2 function in Tableau is used to return the arc tangent value of two given numerical values (x and y). Its results are typically returned in radians. Its syntax is as follows:
Syntax:
ATAN2(x-coordinate, y-coordinate)Example:
ATAN2(5,3) = 0.4CEILING
The CEILING function in Tableau is used to round up float or double values. Its syntax is as follows:
Syntax:
CEILING(Numerical Value)Example:
CEILING(2.24) = 3COS
The COS function in Tableau is used to return the cosine value of a given angle. Its results are typically returned in radians. Its syntax is as follows:
Syntax:
COS(Angle Value)Example:
COS(PI()/4 = 0.707)COT
The COT function in Tableau is used to return the cotangent value of a given angle. Its syntax is as follows:
Syntax:
COT(Angle Value)Example:
COT(PI()/4) = 1DEGREES
The DEGREES function in Tableau is used to return the degree value of a given angle in radians. Its syntax is as follows:
Syntax:
DEGREES(Radian Value)Example:
DEGREES(PI()/4) = 45.0DIV
The DIV function in Tableau is used to return the integer part of a division operation in which the first integer is divided by the second integer. Its syntax is as follows:
Syntax:
DIV(First Integer, Second Integer)Example:
DIV(20,2) = 10EXP
The EXP function in Tableau is used to return the exponential value of a given numerical value. Its syntax is as follows:
Syntax:
EXP(Numerical Value)Example:
EXP(2) = 7.389FLOOR
The FLOOR function in Tableau is used to round a given numerical value to the nearest integer of equal or lesser value. Its syntax is as follows:
Syntax:
FLOOR(Numerical Value)Example:
FLOOR(6.1415) = 6Thus, These are the number functions in tableau.