Tableau: Creating Interactive Data Visualizations

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 ...