Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Introduction to Calculations in Tableau

Learn how to create Calculated Fields in Tableau using formulas, operators, built-in functions, and existing data fields. Understand calculation types, row-level calculations, aggregate calculations, and how to create custom business metrics for meaningful data analysis.

1. What Are Calculations in Tableau?

Calculations in Tableau allow users to create new data values by applying formulas, functions, and expressions to existing fields in a data source. They help transform raw data into meaningful information that can be used for analysis and visualization.

Tableau provides a calculation editor where users can write expressions using fields, operators, constants, and built-in functions. The resulting calculation can be saved as a Calculated Field and reused in worksheets, dashboards, and other analysis.

Example: Calculate Profit

Suppose a sales dataset contains Sales and Cost fields. You want to calculate the profit generated by each transaction.

[Sales] - [Cost]

This expression subtracts Cost from Sales and returns a new calculated value called Profit.

Tableau Calculation Process Sales 100,000 - Cost 60,000 Profit 40,000 Calculated Field = Sales - Cost
Figure: Creating a Profit field from existing Sales and Cost fields.

2. Why Do We Use Calculated Fields?

Real-world datasets do not always contain every metric required for business analysis. Calculated Fields allow analysts to derive additional information without necessarily modifying the original data source.

Common Uses

  • Calculate profit, revenue, and profit margin.
  • Combine multiple fields to create new values.
  • Convert data into required formats.
  • Apply conditional business rules.
  • Calculate percentages and ratios.
  • Classify records into meaningful categories.
  • Create custom KPIs for dashboards.
  • Perform date-based calculations.

Business Example

An organization wants to measure its profit margin for each product. The dataset contains Sales and Profit. A calculated field can be created using:

SUM([Profit]) / SUM([Sales])

The result can be formatted as a percentage and used in business reports.

3. What Is a Calculated Field?

A Calculated Field is a new field created using an expression in Tableau. It can reference existing dimensions, measures, constants, operators, and supported functions.

Once saved, the calculated field appears in the Data Pane and can be used in a worksheet just like other fields, depending on its data type and calculation.

Example: Create a Discount Amount

Assume your dataset contains Sales and Discount Percentage. You want to calculate the discount amount.

[Sales] * [Discount Percentage]

Save the expression as Discount Amount. You can then drag the field into a worksheet to analyze discount values across products or regions.

Calculated Field Components

Component Description Example
Field References an existing data field. [Sales]
Operator Performs an operation between values. +, -, *, /
Function Performs a predefined calculation. SUM(), AVG(), IF()
Constant A fixed value used in an expression. 100, 0.10
Expression Combination of calculation components. [Sales] - [Cost]

4. How to Create a Calculated Field in Tableau

Tableau provides multiple ways to create a Calculated Field. You can create it from the Analysis menu, the Data Pane, or directly from a worksheet.

Method 1: Using the Analysis Menu

  1. Open Tableau Desktop.
  2. Connect to your required data source.
  3. Open a worksheet.
  4. Click the Analysis menu.
  5. Select Create Calculated Field.
  6. Enter a meaningful name for the calculation.
  7. Write the required formula in the editor.
  8. Review the calculation validation message.
  9. Click Apply if required, then click OK.

Method 2: Using the Data Pane

  1. Locate the Data Pane on the left side of the worksheet.
  2. Right-click an empty area in the Data Pane.
  3. Select Create Calculated Field.
  4. Enter the calculation name.
  5. Write the formula.
  6. Save the calculation.

Method 3: Using the Data Pane Search or Field Menu

Depending on the Tableau version and interface, you can also use the field menu or available Data Pane options to create a new calculation.

Creating a Calculated Field Calculation Editor Calculation Name Profit Formula [Sales] - [Cost] Enter a name and valid expression, then save the field.
Figure: Simplified representation of the Tableau calculation editor.

5. Operators Used in Tableau Calculations

Operators are symbols or keywords used to perform mathematical, comparison, and logical operations inside calculated expressions.

5.1 Arithmetic Operators

Operator Operation Example Result
+ Addition 10 + 5 15
- Subtraction 10 - 5 5
* Multiplication 10 * 5 50
/ Division 10 / 5 2
% Modulo 10 % 3 1

5.2 Comparison Operators

Operator Meaning Example
= Equal to [Sales] = 1000
!= or <> Not equal to [Region] != "East"
> Greater than [Sales] > 5000
< Less than [Profit] < 1000
>= Greater than or equal to [Sales] >= 5000
<= Less than or equal to [Sales] <= 5000

5.3 Logical Operators

Operator Purpose Example
AND Both conditions must be true. [Sales] > 1000 AND [Profit] > 100
OR At least one condition must be true. [Region] = "East" OR [Region] = "West"
NOT Reverses a logical condition. NOT ISNULL([Sales])
Tip: Use parentheses to make complex expressions easier to read and to explicitly control the order of operations.

6. Introduction to Tableau Functions

Tableau provides built-in functions that simplify calculations. Functions can perform mathematical, logical, string, date, aggregate, and other operations.

Common Function Categories

Category Purpose Example Functions
Number Perform mathematical calculations. ABS(), ROUND(), CEILING(), FLOOR()
String Manipulate text values. UPPER(), LOWER(), LEFT(), RIGHT()
Date Work with dates and time values. YEAR(), MONTH(), TODAY(), DATEPART()
Logical Evaluate conditions. IF, IIF(), CASE, ISNULL()
Aggregate Summarize measure values. SUM(), AVG(), MIN(), MAX(), COUNT()

Example: ROUND()

ROUND([Sales], 2)

This expression rounds the Sales value to two decimal places.

Example: UPPER()

UPPER([Customer Name])

This expression converts the Customer Name value into uppercase text.

Example: YEAR()

YEAR([Order Date])

This expression returns the year component from the Order Date field.

7. Types of Calculations in Tableau

Tableau calculations can operate at different levels depending on the fields, aggregation, and calculation structure used in the expression.

7.1 Row-Level Calculations

Row-level calculations evaluate an expression for each individual record in the underlying data.

Example:

[Sales] - [Cost]

If the dataset contains 100 transaction records, Tableau evaluates the expression for each record to calculate the profit for that row.

7.2 Aggregate Calculations

Aggregate calculations summarize multiple records into a result based on the level of detail in the view or the aggregation specified in the expression.

Example:

SUM([Sales])

This expression calculates the total Sales value for the relevant group of records.

7.3 Level of Detail Calculations

Level of Detail (LOD) expressions provide control over the level at which a calculation is performed. They allow calculations to be defined independently of, or in relation to, the dimensions in the view.

Example:

{ FIXED [Customer Name] : SUM([Sales]) }

This expression calculates total sales for each customer, regardless of the dimensions displayed in the worksheet, subject to Tableau's filter order of operations.

Important: Row-level, aggregate, and LOD calculations have different behaviors. Understanding their level of detail is important when combining calculations in the same expression.

8. Difference Between Row-Level and Aggregate Calculations

Feature Row-Level Calculation Aggregate Calculation
Evaluation Evaluates individual records. Summarizes records into groups.
Typical Expression [Sales] - [Cost] SUM([Sales])
Output One calculated result per record. One aggregated result per relevant group.
Common Use Calculate transaction-level profit. Calculate total sales by region.
Row-Level vs Aggregate Calculation Row-Level Record 1: 100 - 60 = 40 Record 2: 200 - 80 = 120 Record 3: 150 - 50 = 100 Each record is calculated Aggregate SUM(Profit) 260 Records are summarized
Figure: Individual record calculations compared with aggregated results.

9. Conditional Calculations Using IF Statements

Tableau supports conditional expressions that return different values depending on whether a condition evaluates to TRUE or FALSE.

Example: Sales Performance Classification

Suppose you want to classify products as High Sales or Low Sales based on a sales threshold.

IF [Sales] >= 50000 THEN
    "High Sales"
ELSE
    "Low Sales"
END

This expression checks the Sales value for each record and returns the corresponding category.

Example: Multiple Conditions

IF [Sales] >= 100000 THEN
    "Excellent"
ELSEIF [Sales] >= 50000 THEN
    "Good"
ELSEIF [Sales] >= 10000 THEN
    "Average"
ELSE
    "Low"
END

This expression creates four sales performance categories based on the defined thresholds.

Tip: Use IF and ELSEIF when multiple business conditions need to be evaluated in a calculated field.

10. String Calculations

String calculations are used to manipulate text fields such as customer names, product names, city names, and categories.

Convert Text to Uppercase

UPPER([Customer Name])

Convert Text to Lowercase

LOWER([Customer Name])

Extract Left Characters

LEFT([Product Name], 5)

Extract Right Characters

RIGHT([Product Name], 4)

Combine Text Values

[First Name] + " " + [Last Name]

This expression combines the First Name and Last Name fields into one full-name value.

11. Date Calculations

Date calculations allow users to extract date parts, compare dates, and create time-based business metrics. They are useful for sales trends, monthly reports, order analysis, and performance tracking.

Extract Year

YEAR([Order Date])

Extract Month

MONTH([Order Date])

Extract Day

DAY([Order Date])

Current Date

TODAY()

Calculate Date Difference

DATEDIFF('day', [Order Date], TODAY())

This expression calculates the number of day boundaries between the Order Date and the current date.

12. Handling NULL Values in Calculations

NULL represents a missing or unknown value. When a calculation uses a NULL value, the result may also become NULL depending on the expression and function.

Tableau provides functions such as ISNULL(), IFNULL(), and ZN() to help identify or handle NULL values.

Example: Check NULL Values

ISNULL([Sales])

Returns TRUE when Sales is NULL and FALSE when it is not NULL.

Example: Replace NULL with Zero

IFNULL([Sales], 0)

Returns the Sales value when it is not NULL; otherwise, it returns zero.

Example: ZN Function

ZN([Profit])

Returns the Profit value when it is not NULL; otherwise, it returns zero.

Important: Replacing NULL with zero changes the meaning of the data in some business scenarios. Apply this only when zero is an appropriate replacement for the missing value.

13. Validating Calculated Fields

Tableau checks calculation expressions for syntax and other calculation errors. It is important to validate formulas before using them in reports.

Common Validation Issues

Issue Possible Reason Solution
Unknown field Field name is incorrect or unavailable. Verify the field name in the Data Pane.
Incorrect syntax Missing parentheses or END keyword. Review the calculation syntax.
Data type mismatch Incompatible data types are used. Use appropriate conversion functions.
Aggregate and non-aggregate mix Aggregated and row-level expressions are combined incorrectly. Review the calculation level and aggregation.
NULL result Input values are NULL or expression returns NULL. Review the input data and NULL handling.

14. Best Practices for Tableau Calculations

  • Use clear and meaningful names for Calculated Fields.
  • Keep formulas simple and readable.
  • Use parentheses in complex expressions.
  • Understand whether the calculation is row-level or aggregate.
  • Check data types before performing calculations.
  • Handle NULL values according to business requirements.
  • Validate formulas before using them in dashboards.
  • Reuse existing calculated fields where appropriate.
  • Document complex calculations for easier maintenance.
  • Verify calculated results against sample records.

Summary

Calculations in Tableau allow users to create new values and business metrics from existing data fields using formulas, operators, and built-in functions. Calculated Fields can be created through the Analysis menu or Data Pane and reused across worksheets and dashboards. Tableau supports arithmetic, comparison, logical, string, date, and aggregate operations. Understanding row-level calculations, aggregate calculations, conditional expressions, and NULL handling helps analysts build accurate and meaningful reports. These concepts provide the foundation for advanced Tableau calculations and business analysis.