One of Tableau's core functions is to automatically summarize, or aggregate, your data the moment you bring it into a view. While this is incredibly useful for creating high-level summaries like bar charts or single KPI cards, you'll sometimes need to see the individual data points that make up those summaries. This tutorial will show you exactly how to uncheck "Aggregate Measures" in Tableau and explain why this simple step is a key skill for deeper analysis.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Measure Aggregation in Tableau?

When you drag a measure like 'Sales' onto the Rows shelf in Tableau, you won’t see a list of every single sale. Instead, you'll see a single value: SUM(Sales). Tableau has automatically aggregated all the individual sale values into a total sum. This is the default behavior for any measure you use.

Aggregation is the process of taking many individual values and combining them into a single, summary value. Tableau does this to help you quickly understand large datasets. Instead of overwhelming you with thousands of rows, it provides a meaningful summary right away.

The most common types of aggregation you'll see are:

• SUM: Adds all the numbers together.
• AVG (Average): Calculates the average of the numbers.
• MIN (Minimum): Finds the smallest value.
• MAX (Maximum): Finds the largest value.
• COUNT: Counts the number of rows or items.
• COUNTD (Count Distinct): Counts the number of unique items.

This default behavior is a feature, not a bug. It's the engine that powers most common charts, like a bar chart showing total sales per region or a line chart showing average revenue over time. However, to unlock certain types of analysis, you need to know how to turn it off.

Why Disaggregate Your Data? The "When" and "Why"

Turning off aggregation allows you to work with your data at its most granular, row-level detail. This is essential for a few key scenarios that top-level summaries can't handle.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Building Scatter Plots

This is the most common reason to uncheck Aggregate Measures. A scatter plot is designed to show the relationship between two measures for each individual point in your data. For example, you might want to see if there's a correlation between Profit and Sales for every single order. If you leave aggregation on, Tableau will show you one single mark representing the total sum of profit versus the total sum of sales, which isn't very useful. By disaggregating, each order appears as its own dot on the chart, instantly revealing patterns, clusters, and potential correlations.

Identifying Outliers

Aggregated views can hide important outliers. A single bar showing "Average Sales" might look perfectly normal, but when you disaggregate the data, you might see that the average is being skewed by a few unusually high or low-value transactions. Plotting every individual point makes it immediately obvious which data points fall far outside the normal range.

Viewing Raw Data Tables

Sometimes you just want to see your data presented like a spreadsheet, with every row visible. This is helpful for spot-checking data, finding specific records, or exporting a detailed list. Unchecking aggregation will display every single row from your data source that meets your filter criteria, giving you full visibility.

How to Uncheck Aggregate Measures: A Step-by-Step Guide

The process is straightforward. We'll use the "Sample - Superstore" dataset that comes with Tableau to walk through creating a simple scatter plot.

Step 1: Set Up Your Initial View

First, open Tableau and connect to the "Sample - Superstore" data source.

1. Drag the Sales measure to the Columns shelf.
2. Drag the Profit measure to the Rows shelf.

You'll see a single point on your view. If you hover over it, you'll see it represents the sum of all sales and the sum of all profits in your entire dataset. This is the aggregated view.

Your view shows one mark: SUM(Sales) vs. SUM(Profit).

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Navigate to the Analysis Menu

At the top of the Tableau window, you will see a menu bar with options like "File," "Data," and "Worksheet." Click on the Analysis menu.

Step 3: Uncheck Aggregate Measures

Inside the Analysis menu dropdown, you will see an option called Aggregate Measures. By default, it will have a checkmark next to it. Simply click this option to uncheck it.

Analysis > Aggregate Measures (click to remove the checkmark)

What Happens Next?

The moment you uncheck the box, your view will transform. The single point will "explode" into thousands of individual marks, each representing a single row (or order, in this case) from your Superstore data. Your axes labels will also change from SUM(Sales) and SUM(Profit) to just Sales and Profit, indicating that you are now viewing the measures at the row level.

You have successfully disaggregated your data and created a basic scatter plot!

Refining Your Disaggregated View

A cloud of dots is a good start, but it becomes more powerful when you add dimensions to provide context. Dimensions break down your data and can be used on the Marks card to add color, size, and shape to your individual points.

For example, let's add context to our Sales vs. Profit scatter plot:

• Drag the Category dimension from the Data pane onto the Color mark on the Marks card.

Now, each dot is colored based on whether it belongs to the 'Furniture', 'Office Supplies', or 'Technology' category. You can immediately see if one category is consistently more or less profitable than others.

• Drag the Region dimension to the Shape mark.

You can now see both the category (by color) and region (by shape) for every single order, right within the scatter plot. This level of analysis is impossible with aggregated data.

Important Considerations and Tips

Before you start disaggregating every view, keep a few things in mind.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Performance Can Be an Issue

Disaggregating tells Tableau to render a mark for every single row in your dataset. If your data source has millions of rows, this can slow down your workbook or even cause it to become unresponsive. A good practice is to apply filters before disaggregating your data to reduce the number of marks Tableau needs to draw.

2. Not All Charts Should Be Disaggregated

This feature is perfect for scatter plots but makes little sense for other chart types. Disaggregating a bar chart, for example, will result in thousands of tiny marks stacked on top of one another instead of a clean, summary bar — defeating the purpose of the chart entirely. Use aggregation for summaries and disaggregation for detailed, row-level views.

3. Add Dimensions for Clarity

A disaggregated view full of dots can be just as confusing as an aggregated one if it lacks context. Always use dimensions on the Color, Size, Shape, and Detail properties on the Marks card to add layers of meaning to your individual marks.

Final Thoughts

Tableau’s choice to aggregate measures by default is a powerful feature that simplifies data analysis for most common charts. Understanding how to turn it off by unchecking "Aggregate Measures" in the Analysis menu is a critical skill that opens the door to more granular views, such as scatter plots that reveal underlying relationships and outliers in your data.

Learning the nuances of tools like Tableau can feel like a steep climb, especially when you're trying to figure out which menu option to click for a specific result. At Graphed you handle this complexity for you. Instead of hunting for the "Aggregate Measures" option, you could simply ask, “Create a scatter plot of sales vs. profit for each order,” and get the visualization you need in seconds. We connect to your data and let you build dashboards and ask questions in plain English, turning hours of configuration into a brief conversation.