Tableau – Number Functions
Tableau Function Categories Tableau – Number Functions Category: Aggregation functions Number functions in Tableau are built-in operations that allow users to perform arithmetic, rounding, and numeric manipulations on fields containing
Category: Aggregation functions
Number functions in Tableau are built-in operations that allow users to perform arithmetic, rounding, and numeric manipulations on fields containing numerical data. These functions transform raw numbers into more meaningful, interpretable, or aggregated values for analysis and visualization.
Purpose
The primary purpose of number functions in Tableau is to:
Enable mathematical computations on data fields.
Support data normalization, rounding, or truncation.
Facilitate advanced calculations for metrics like percentages, averages, or growth rates.
Ensure clean and consistent numerical data representation in dashboards.
Practical Use Cases
Financial Analysis: Calculating profits, revenue growth percentages, and rounding amounts to nearest currency units.
Performance Metrics: Normalizing KPIs or performance ratios.
Data Cleaning: Converting null or string-based numeric fields into usable numbers.
Dashboard Insights: Aggregating sales, inventory, or customer metrics with precise calculations.
Advanced Analytics: Implementing mathematical formulas, such as weighted averages, exponential growth, or cumulative sums.
| Function | Description |
|---|---|
| ABS | Returns the absolute (non-negative) value of a given number. |
| ACOS | Returns the arccosine (inverse cosine) of a number, expressed as an angle. |
| ASIN | Returns the arcsine (inverse sine) of a given number, expressed as an angle. |
| ATAN | Returns the arctangent (inverse tangent) of a given number, expressed as an angle. |
| ATAN2 | Returns the arctangent of the ratio between two numbers (x and y), measured in radians. |
| CEILING | Rounds a number up to the nearest integer greater than or equal to it. |
| COS | Returns the cosine value of an angle. |
| COT | Returns the cotangent value of an angle. |
| DEGREES | Converts an angle from radians to degrees. |
| DIV | Returns only the integer portion of a division where one integer is divided by another. |
| EXP | Returns the value of e (Euler’s number) raised to the power of the given number. |
| FLOOR | Rounds a number down to the nearest integer less than or equal to it. |
| HEXBINX | Maps an (x, y) coordinate to the x-coordinate of the closest hexagonal bin (side length = 1). Scaling may be required. |
| HEXBINY | Maps an (x, y) coordinate to the y-coordinate of the closest hexagonal bin (side length = 1). Scaling may be required. |
| LN | Returns the natural logarithm (base e) of a number. |
| LOG | Returns the logarithm of a number for a specified base. |
| MAX | Returns the larger of two values of the same data type. Can also be used as an aggregate function on a single field. |
| MIN | Returns the smaller of two values of the same data type. Can also be used as an aggregate function on a single field. |
| PI | Returns the constant π (pi), approximately equal to 3.14159. |
| POWER | Raises a number to a specified exponent or power. |
| RADIANS | Converts an angle measured in degrees to radians. |
| ROUND | Rounds a number to a defined number of decimal places. If decimals are not specified, it rounds to the nearest whole number. |
| SIGN | Returns -1 if the number is negative, 0 if it’s zero, and 1 if it’s positive. |
| SIN | Returns the sine value of an angle. |
| SQRT | Returns the square root of a number. |
| SQUARE | Returns the square (number multiplied by itself) of a value. |
| TAN | Returns the tangent value of an angle. |
| ZN | Returns the expression if it’s not null; otherwise, it returns zero. Useful for replacing null values with zeros. |
Maximize the potential of Tableau and elevate your data insights with our expert consulting services. Whether you need assistance with advanced calculations, help designing interactive dashboards, or support in optimizing your data visualizations for better performance, our skilled Tableau consultants are ready to provide tailored solutions for your business. Visit our Tableau consultancy page to learn more about how we can empower your organization to make more informed, data-driven decisions.
Number functions in Tableau are operations that perform calculations and manipulations on numerical fields for analysis and visualization.
You can use functions like ROUND(number, num_digits), CEILING(number), or FLOOR(number) to round values to desired precision.
Yes, the ZN() function converts null values to zero, ensuring calculations work without errors.
INT() truncates decimals to return an integer, while FLOAT() converts integers to decimal numbers for precise calculations.
They are used in calculated fields, aggregations, KPIs, and visualizations to clean, format, and analyze numeric data.