Easy-to-Read Tableau Reference Guide on Calculated Fields – Number Functions

Easy-to-Read Tableau Reference Guide on Calculated Fields

It’s not possible for everyone to ace in Tableau, at least not yet. Tableau is a versatile data visualization application that facilitates users to examine structured data virtually, while displaying information in several interactive graphic perspectives. Though it’s very easy to use and a lot of individuals use Tableau Desktop for creating data visualizations, it churns out best results when employed by expert hands.

Thus, to help Tableau stalwarts, we’re here with a set of blogs on Tableau Essentials that will help you dig into the basics of using this powerful data visualization software, especially Desktop versions 8.1 and 8.2. This blog is a continuation of the Tableau blog on Logical Functions. It was part I and this one, which exclusively sheds light on Number Functions is part II. Here, we will deeply focus on another group of functions implemented for Tableau’s calculated fields. Scroll below to get started…

First, open the Calculated Fields window, right-click on the sidebar (Data window) and choose Create Calculated Field:

TECFNumber1_0-01

Now, in the Calculated Field Window, choose Number from the Functions drop-down menu:

TECFNumber5-02

LN FUNCTION

LN(number)

It returns the natural log of the number. Now, if the numbers appear to be less than or equal to zero, the function tends to return NULL.

For an example,

TECFNumber6-03

LOG FUNCTION

LOG(number,[base])

LOG brings back the log of the number for a given base. In case, there’s no base, the function will use base 10 by default.

For an example,

TECFNumber7-04

PI FUNCTION

PI()

It helps return the numeric constant of PI.

TECFNumber8-05

POWER FUNCTION

POWER(number, function)

This function increases the number to the defined power.

For an example,

TECFNumber9

RADIANS FUNCTION

RADIAN(number)

This is a superb function to convert numbers from degrees to radians.

TECFNumber10

ROUND FUNCTION

ROUND(number,[decimals])

Use this function to round off any number to the nearest integer or to a particular number of decimal places.

For an instance,

TECFNumber11

SIGN FUNCTION

SIGN(number)

This function brings back the sign of a number.

In case of positive numbers, it returns a 1.

For zero, it returns a 0.

For negative numbers, the function returns a -1.

For an example,

TECFNumber12

SQRT FUNCTION

SQRT(number)

It returns the square root of a number.

TECFNumber13

SQUARE FUNCTION

SQUARE(number)

This function returns the square of the number.

For an instance,

TECFNumber14

ZN FUNCTION

ZN(expression)

The specialty of ZN function is that it evaluates any expression.

If the function is NULL, it will return a value of 0, and if not, the expression is returned as before.

For example,

TECFNumber15

STATISTICAL

MAX FUNCTION

MAX(number, number)

This function returns the maximal of two expressions for each record or an expression throughout all records. However, the two statements have to be the same type. If one or the other argument turns NULL, the function returns a value of NULL.

TECFNumber16

MIN FUNCTION

MIN(number, number)

Just like MAX function, MIN function too returns the minimal of an expression across the records or minimal of two expressions for a particular record. The two arguments must be similar in type. Also, if one or the other arguments hold NULL, MIN returns a value NULL.

TECFNumber17

TRIGONOMETRIC

ACOS FUNCTION

ACOS(number)

ACOS function returns the arc cosine of the number and the outcome is in radians.

Take a look,

TECFNumber18

ASIN FUNCTION

ASIN(number)

This function returns the arc sine of the number. And as usual the outcome is in radians.

TECFNumber19

ATAN FUNCTION

ATAN(number)

It returns the arc tangent of any number, and as usual the outcomes is in radians.

TECFNumber20

ATAN2 FUNCTION

ATAN2(y number, x number)

It’s quite similar to the previous ATAN FUNCTION, except it’s used for two given numbers. Otherwise, all remains same.

TECFNumber21

COS FUNCTION

COS(number)

Cos returns the cosine of an angle. Just mention the angle in radians.

For example,

TECFNumber22

COT FUNCTION

COT(number)

COT FUNCTION returns the cotangent of an angle. Marking of angles in radians is important.

TECFNumber23

SIN FUNCTION

SIN(number)

This function returns the sine of an angle. For example,

TECFNumber24

TAN FUNCTION

TAN(number)

 TAN FUNCTION returns the tangent of an angle. You just need to mention the angle in radians and that’s it.

TECFNumber25

Typically, it all depends on the nature of your business; if it needs, you have to go through Number Functions routinely, otherwise not. Now, if you really have to use them then peruse over Tableau course details at DexLab Analytics. Being a premier Tableau training institute in Gurgaon, DexLab will offer a whole new layer of insight into Tableau Essentials.

 

The article has been sourced from – https://interworks.com/blog/ccapitula/2015/04/07/tableau-essentials-calculated-fields-number-functions

 

Interested in a career in Data Analyst?

To learn more about Machine Learning Using Python and Spark – click here.

To learn more about Data Analyst with Advanced excel course – click here.
To learn more about Data Analyst with SAS Course – click here.
To learn more about Data Analyst with R Course – click here.
To learn more about Big Data Course – click here.

May 18, 2018 5:57 am Published by , , , , , ,

, , , ,

Comments are closed here.

...

Call us to know more