Introduction:
Tableau invokes multiple mathematical functions for data analysis and Visualization. Similar to other programming languages or analysis tools, Tableau have several mathematical calculation including number, string, logical, aggregate functions, etc..
These functions help in visualizing the data more appropriately. The function included in tableau are as follows:
1) Aggregation Function
2) Number Function
3) Date Function
4) String Function
5) Logical Function
Aggregation Functions
Aggregation is applied to a measure by default in Tableau. Tableau queries the data source when you drag a measure into the display, and the data source returns the aggregated results. This improves Tableau's efficiency and clarifies your findings.
An aggregate function is one that combines the data from several lines into a single summative value. Tableau provides a range of integrated functions that facilitate the calculation of aggregations, including total, average, minimum, amount, and so on.
a) SUM
The Tableau Sum function is used to calculate the sum of data inside the selected measure.
SUM(Measure)
Eg: SUM([Sales])
b) AVG
The Tableau AVG function is used to calculate the average of data inside the selected measure.
AVG(Measure)
Eg: AVG([Sales])
c) MIN
MIN function in tableau is used to find the minimum value from the measure selected.
MIN(Measure)
Eg: MIN([Sales])
d) MAX
MAX function in tableau is used to find the maximum value from the measure selected.
MAX(Measure)
Eg: MAX([Sales])
e) STDDEV
The STDEV function in tableau calculates the statistical standard deviation of all values in a given measure using a population sample.
STDDEV(Measure)
Eg: STDDEV([Sales])
f) STDDEVP
The STDEVP function in tableau calculates the statistical standard deviation of all values in the provided measure using a biased population.
STDDEVP(Measure)
Eg: STDDEVP([Sales])
g) PERCENTILE
The Percentile function in tableau returns the percentile value of the provided measure according to the specified integer.
PERCENTILE (Measure, number)
Common percentiles used are 25th, 50th, 75th, and 100th percentile.
h) MEDIAN
The MEDIAN function in tableau is used to calculate the median of a measure across the identified data. Median is also called as 50th percentile as half of observation are above and half observation below in the given measure.
MEDIAN(Measure)
Eg: MEDIAN([SALES])
i) COUNT
COUNT function in tableau is used to return the number of items in the given measure, where null values are not excluded.
COUNT(Measure)
Eg: COUNT([SALES])
j) COUNTD
COUNTD function in tableau is used to return the unique number of items from the given measure.
COUNTD(Measure)
Eg: COUNTD([SALES])
k) VAR
VAR is used to calculate the statistical variances of all values in each expression using a population sample.
VAR (Measure)
Eg: VAR([Sales])
l) VARP
The VARP function is used to calculate the statistical variance of all values in each expression over the whole population.
VARP (Measure)
Eg: VARP([Sales])
m) ATTR
ATTR function in tableau is used to return the measures value if it contains single value for all rows.
ATTR (Measure)
Eg: ATTR([Sales])
CORR
The CORR function in tableau is used to calculate the Pearson Correlation coefficient for two non- aggregated variables.
CORR (Measure1, Measure2)
Eg: CORR([Profit], [Sales])
NUMBER FUNCTIONS
Number functions are used to perform computations on the data values in calculated fields. Number functions can only be used with fields that contain numerical values.
a) COS
The COS function in tableau is used to calculate the COSINE value for the given angle. The result obtained is in form of radius.
COS (Angle Value)
Eg: COS (PI ()/4=0.707)
b) SIN
The SIN function in tableau is used to calculate sine of the angle specified in form of radians.
SIN (Angle Value)
Eg: SIN (PI ()/4=0.708)
c) COT
The COT function in tableau is used to calculate cotangent of the angle specified in form of radians.
COT (Angle Value)
Eg: COT (PI ()/4=1)
d) DEGREES
The DEGREES function in tableau is used to calculate the value of Radians in form of DEGREES.
DEGRESS (Radian Value)
Eg: DEGRESS (PI ()/4= 45)
e) DIV
The DIV function in tableau is used to find the integer part of the result obtained from the division operation.
DIV (FIRST INTEGER, SECOND INTEGER)
Eg: DIV (20,4) =5
f) EXP
The EXP function in tableau is used to calculate the exponential value of the given number.
EXP(NUMBER)
Eg: EXP (2) = 7.389
g) FLOOR
The FLOOR function in tableau is used to round a number to the nearest integer value.
FLOOR(NUMBER)
Eg: FLOOR (2.234) = 2
h) SQUARE
The SQUARE function in tableau is used to calculate the square of the given number.
SQUARE(NUMBER)
Eg: SQUARE (9) = 81
i) ZN
The ZN function in tableau is used for returning the expression if it is not null. Otherwise, it will return the value as zero. The main purpose of this function is to replace the null values by zero.
ZN(Measure)
Eg: ZN(SUM([Sales]) = 23,95,894.
j) ABS
The ABS function in tableau is used to calculate the absolute value of the given number.
ABS(Number)
Eg: ABS (-10) = 10
k) CEILING
The CEILING function in tableau are used to round off floating or double values.
CEILING(Number)
Eg: CEILING(2.26)= 3
Simple and Easy of learning