Book Image

Creating Data Stories with Tableau Public

Book Image

Creating Data Stories with Tableau Public

Overview of this book

Table of Contents (18 chapters)
Creating Data Stories with Tableau Public
Credits
About the Author
Acknowledgments
About the Author
About the Reviewer
www.PacktPub.com
Preface
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...