Tableau functions
Functions are the options Tableau uses to create calculations. Tableau has a robust set of functions for developers to create an almost infinite number of calculations with many capabilities. You will not need to learn all functions at this level as many are used for more advanced applications, but we will cover the foundational functions in the following subsections.
Number functions
Numerical fields or fields with #
in front of them can be used in calculations to create or refer to something that can be measured. Number functions can only be applied with numerical fields. The number functions that are most common and will be referenced in the exam appear in the following list:
ABS
: Provides the absolute or non-negative value of a number from the field used. It changes all negative numbers to the positive version of the number and keeps non-negatives the same—for example,ABS(-10) =
10
.MAX
: Finds the maximum value of the field (based on...