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:
- To calculate the square root of a number, right-click on the Measures pane and select Create Calculated Field.
- In the Name box, enter
SquareRootofSales
as shown in the following screenshot: - 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.