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) = 15

ACOS

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.04719

ASIN

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.5235

ATAN

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.565

ATAN2

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.4

CEILING

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) = 3

COS

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) = 1

DEGREES

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.0

DIV

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) = 10

EXP

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.389

FLOOR

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) = 6

Thus, These are the number functions in tableau.