TABLEAU NUMBER FUNCTIONS
Mathematical Functions:
ABS: Returns the absolute value of a number.
ROUND: Rounds a number to a specified number of decimal places.
CEILING: Rounds a number up to the nearest integer.
FLOOR: Rounds a number down to the nearest integer.
INT: Truncates the decimal portion of a number, returning the integer part.
POWER: Raises a number to a specified exponent.
SQRT: Calculates the square root of a number.
LOG: Calculates the natural logarithm of a number.
Aggregation Functions:
SUM, AVG, MIN, MAX: Perform basic aggregations on numeric values within a dataset. These functions are often used in combination with other functions to summarize data.
Conditional Functions:
IF: Allows you to create conditional calculations based on numeric values. For example, you can use this function to create calculated fields with conditional logic.
Rounding and Precision Functions:
TRUNC: Truncates a number to a specified number of decimal places.
ROUNDUP (or CEIL): Rounds a number up to the nearest specified multiple.
ROUNDDOWN (or FLOOR): Rounds a number down to the nearest specified multiple.
SIGN: Returns the sign of a number (-1 for negative, 0 for zero, 1 for positive).
Random Number Functions:
RAND: Generates a random number between 0 and 1.
RANK: Assigns a rank to each row in a dataset based on a specified numeric field.
Formatting Functions:
STR: Converts numbers, dates, or other data types to string format.
FORMAT: Formats a number based on a specified format string.
Percentage Functions:
PERCENTILE: Calculates the percentile rank of a value within a dataset.
PERCENTRANK: Calculates the rank of a value as a percentage of the total values.