Tableau SQL Mathematical Functions
Mathematical Functions within Tableau.
Tableau SQL Mathematical Functions
Mathematical Functions within Tableau.
A. ABS:
AbsoluteValue = ABS(-10)
This example returns the absolute value of -10, resulting in 10.
B. SQRT:
SquareRoot = SQRT(25)
This example calculates the square root of 25, resulting in 5.
C. POW:
PowerResult = POW(2, 3)
This example raises 2 to the power of 3, resulting in 8.
D. LN:
NaturalLog = LN(10)
This example calculates the natural logarithm of 10, resulting in approximately 2.3026.
E. ROUND:
RoundedValue = ROUND(3.14159, 2)
This example rounds the number 3.14159 to 2 decimal places, resulting in 3.14.
223