#### Overview of this book

Creating Data Stories with Tableau Public
Credits
Acknowledgments
www.PacktPub.com
Preface
Free Chapter
Getting Started with Tableau Public
Tableau Public Interface Features
Connecting to Data
Visualization – Tips and Types
Calculations
Level of Detail and Table Calculations
Dashboard Design and Styling
Filters and Actions
Index

## The number functions

Number functions include several functions that you may be familiar with owing to working with applications such as ROUND and ABS. Many of us may not have used several of these functions, such as the trigonometric and exponential functions, since our high school math class. There are some number functions that we will use extensively, such as MIN and MAX, while there are others that have limited uses, such as the geometric and trigonometric functions.

Number functions include the following, in order of decreasing precedence:

• ABS: This takes the absolute value of a number. It is commonly found in the denominator of table calculations.

• CEILING: This rounds up a decimal to its nearest integer and is the opposite of INT.

• FLOOR: This rounds a decimal down to its nearest integer.

• MAX and MIN: These take the maximum and minimum values in a sequence respectively. They are also considered to be string functions.

• ROUND: This allows you to specify how many decimals to round up a...