Using predefined functions

Tableau provides many predefined functions that help us manipulate data in a certain way. These functions are divided by the type of manipulation, such as functions of numeric and string data types, or aggregate operations.

Getting ready

Let's use the sample file Sample – Superstore Sales (Excel). Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.

How to do it...

Once the data is loaded on the worksheet, perform the following steps to create a new calculated field:

  1. To calculate the square root of a number, right-click on the Measures pane and select Create Calculated Field.
  2. In the Name box, enter SquareRootofSales as shown in the following screenshot:
  3. In the Formula box, enter SQRT([Sales]) ...

Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial