O'Reilly logo

Creating Data Stories with Tableau Public by Matt Floyd, Ashley Ohmann

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required