Difference and percent difference in Tableau - Step-by-Step Guide

Introduction

This feature helps you compare values by showing how much one number changes from another. It calculates the difference and the percent difference, making it easy to see growth or decline between data points.

When you want to see how sales this month compare to last month.

When you need to track the change in website visitors between two weeks.

When you want to analyze the increase or decrease in expenses year over year.

When you want to highlight the percentage change in customer satisfaction scores.

When you want to compare product performance between two regions.

Steps

Step 1: Open your Tableau workbook

- Tableau Desktop main window

Your data and worksheets are visible

Step 2: Drag the measure you want to analyze (e.g., Sales) to the Rows shelf

- Rows shelf

A chart or table showing the measure values appears

Step 3: Drag the dimension you want to compare by (e.g., Month) to the Columns shelf

- Columns shelf

Data is split by the chosen dimension, showing values side by side

Step 4: Right-click the measure on the Rows shelf and select 'Quick Table Calculation' > 'Difference'

- Measure pill on Rows shelf

The chart updates to show the difference between each data point and the previous one

Step 5: Right-click the measure again and select 'Quick Table Calculation' > 'Percent Difference'

- Measure pill on Rows shelf

The chart updates to show the percent difference between each data point and the previous one

Step 6: Click the measure pill, select 'Edit Table Calculation' to adjust calculation direction if needed

- Measure pill context menu

You can change how Tableau calculates difference (e.g., Table Across, Table Down)

Before vs After

Before

A bar chart shows monthly sales values: Jan $1000, Feb $1200, Mar $1100

After

After applying Difference, the chart shows: Feb $200, Mar -$100; after Percent Difference, it shows: Feb 20%, Mar -8.33%

Settings Reference

Quick Table Calculation Type

📍 Right-click measure pill > Quick Table Calculation

Choose the type of calculation to apply to your measure for comparison

Default: None

Edit Table Calculation

📍 Right-click measure pill > Edit Table Calculation

Control the direction and scope of the calculation to match your data layout

Default: Table Across

Common Mistakes

Applying difference calculation without setting the correct calculation direction

The difference may calculate across wrong dimension causing incorrect results

Use 'Edit Table Calculation' to set calculation direction matching your data layout

Confusing difference with percent difference

Difference shows absolute change, percent difference shows relative change; mixing them can mislead analysis

Choose the calculation type that fits your question: absolute change or relative change

Summary

Difference and percent difference help compare values between data points easily.

Use Quick Table Calculation to apply these comparisons quickly in Tableau.

Always check and adjust calculation direction to get accurate results.

Practice

1. What does the Difference calculation in Tableau typically show?

easy

A. The total sum of all values

B. The average value over time

C. How much a value changed between two points

D. The maximum value in a dataset

Solution

1. Step 1: Understand the meaning of Difference

   Difference measures the change in value from one point to another, showing increase or decrease.

2. Step 2: Compare with other options

   Sum, average, and maximum describe different calculations unrelated to change between points.

3. Final Answer:

   How much a value changed between two points -> Option C

4. Quick Check:

   Difference = Change amount [OK]

Hint: Difference = New value minus old value [OK]

Common Mistakes:

• Confusing difference with total sum
• Thinking difference shows average
• Mixing difference with maximum value

2. Which of the following Tableau calculations correctly computes the percent difference between the current and previous value?

easy

A. ([Current Value] - [Previous Value]) / [Previous Value]

B. ([Previous Value] - [Current Value]) / [Current Value]

C. [Current Value] + [Previous Value] / [Previous Value]

D. [Current Value] * [Previous Value]

Solution

1. Step 1: Recall percent difference formula

   Percent difference = (New - Old) / Old, showing change relative to original.

2. Step 2: Match formula to options

   ([Current Value] - [Previous Value]) / [Previous Value] matches formula exactly; others either reverse or misuse operations.

3. Final Answer:

   ([Current Value] - [Previous Value]) / [Previous Value] -> Option A

4. Quick Check:

   Percent difference = (New - Old) / Old [OK]

Hint: Percent difference = difference divided by previous value [OK]

Common Mistakes:

• Swapping numerator terms
• Dividing by current value instead of previous
• Using addition or multiplication instead of division

3. Given this Tableau calculated field:
LOOKUP(SUM([Sales]), 0) - LOOKUP(SUM([Sales]), -1)
What does this calculation return?

medium

A. The percent difference in sales between current and previous row

B. The total sales for all rows

C. The sum of sales for the previous row only

D. The difference in sales between the current and previous row

Solution

1. Step 1: Understand LOOKUP function usage

   LOOKUP(SUM([Sales]), 0) returns current row sales; LOOKUP(SUM([Sales]), -1) returns previous row sales.

2. Step 2: Calculate difference

   Subtracting previous from current gives the difference in sales between rows.

3. Final Answer:

   The difference in sales between the current and previous row -> Option D

4. Quick Check:

   LOOKUP difference = sales change [OK]

Hint: LOOKUP with offset -1 gets previous row value [OK]

Common Mistakes:

• Thinking it calculates percent difference
• Assuming it sums all sales
• Confusing current and previous row values

4. You wrote this Tableau formula to calculate percent difference:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / SUM([Sales])
But the results seem incorrect. What is the likely error?

medium

A. Not using WINDOW_SUM instead of SUM

B. Dividing by current sales instead of previous sales

C. Subtracting current sales from previous sales

D. Using LOOKUP with offset -1 incorrectly

Solution

1. Step 1: Analyze denominator in formula

   The formula divides by SUM([Sales]) which is current sales, but percent difference should divide by previous sales.

2. Step 2: Identify correct denominator

   Correct formula divides by LOOKUP(SUM([Sales]), -1) to get previous sales as denominator.

3. Final Answer:

   Dividing by current sales instead of previous sales -> Option B

4. Quick Check:

   Percent difference denominator = previous value [OK]

Hint: Divide by previous value, not current, for percent difference [OK]

Common Mistakes:

• Using current value as denominator
• Confusing subtraction order
• Misusing LOOKUP offset

5. You want to create a Tableau dashboard showing monthly sales percent difference compared to the previous month. Which approach correctly calculates this and handles months with zero sales without errors?

hard

A. Use (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / NULLIF(LOOKUP(SUM([Sales]), -1), 0) to avoid division by zero

B. Use (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / SUM([Sales]) ignoring zero sales

C. Use SUM([Sales]) / LOOKUP(SUM([Sales]), -1) without subtraction

D. Use WINDOW_SUM(SUM([Sales])) - WINDOW_SUM(SUM([Sales])) for difference

Solution

1. Step 1: Calculate percent difference with zero check

   Percent difference = (Current - Previous) / Previous; use NULLIF to avoid division by zero errors when previous sales are zero.

2. Step 2: Evaluate options for correctness

   Use (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / NULLIF(LOOKUP(SUM([Sales]), -1), 0) to avoid division by zero uses NULLIF to prevent errors; others either divide by current or ignore zero sales causing errors or wrong results.

3. Final Answer:

   Use (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / NULLIF(LOOKUP(SUM([Sales]), -1), 0) to avoid division by zero -> Option A

4. Quick Check:

   Use NULLIF to handle zero denominator [OK]

Hint: Use NULLIF to prevent division by zero in percent difference [OK]

Common Mistakes:

• Dividing by current sales instead of previous
• Ignoring zero sales causing errors
• Using sum differences without percent calculation