Where is the Analysis Menu in Tableau?

Dragging dimensions and measures onto a Tableau canvas is just the beginning. The real power of a visualization comes from adding context, comparison, and statistical depth. This is where Tableau's Analysis menu shines, transforming your simple charts into powerful analytical tools. This guide will walk you through the most valuable features within the Analysis menu and show you how to use them to find meaningful insights in your data.

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 the Analysis Menu and Why Bother?

The Analysis Menu in Tableau is the command center for adding analytical objects and performing basic to intermediate statistical operations directly on your visualization. Think of it as a toolkit that lets you add layers of information to your charts without writing complex code or calculations from scratch.

Instead of just showing raw numbers, this menu helps you answer more important business questions, such as:

• What are the total sales for each region and for the entire company? (Totals)
• How does this month's website traffic compare to the average? (Reference Lines)
• Are our ad conversions generally trending up or down over time? (Trend Lines)
• Based on past performance, what can we expect our revenue to be next quarter? (Forecast)
• Are there natural groupings or segments within our customer base? (Cluster)

Let's break down the features that help you answer these questions and more.

Totals: Adding Quick Summaries

One of the most frequent tasks in reporting is adding grand totals and subtotals. The Analysis menu makes this a simple, two-click process, eliminating the need to do separate calculations in a spreadsheet.

Imagine you have a text table showing sales by Region and Category. The raw table is useful, but totals provide immediate, high-level context.

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

How to Add Totals:

1. Navigate to Analysis > Totals from the top menu bar.
2. Here you'll see several options:

Subtotals are added automatically when you have multiple dimensions in your rows or columns. For example, if you drill down from Category to Sub-Category, a subtotal for each category will appear. You can toggle this with Analysis > Totals > Add All Subtotals.

Practical Tip: Use totals to quickly sanity-check your data. The grand total should often match a known business metric, giving you confidence in your visualization.

Percentages: Providing Proportional Context

Raw numbers don't always tell the whole story. Knowing that you made $50,000 in sales in the West region is good, but knowing that it represents 40% of your total company sales is a much richer insight. The Analysis menu makes it easy to apply these percentage calculations.

How to Add Percentages:

1. Go to Analysis > Percentage of from the top menu.
2. Select how you want to calculate the percentage:

This feature instantly changes your numbers into percentages, helping you and your stakeholders focus on proportionality and contribution rather than just an absolute value.

Reference Lines, Bands, Distributions, and Boxes

This is arguably the most powerful section of the Analysis menu for adding business context. It allows you to overlay lines and shaded areas onto your chart to represent key statistical values like averages, constants, or quartiles.

Imagine you're looking at a bar chart of monthly sales. Is $120,000 in sales a good month or a bad month? A reference line showing the average monthly sales gives you an instant benchmark.

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

How to Add a Reference Element:

1. Right-click on the quantitative axis (like 'Sales' or 'Sessions') where you want to add the line or band.
2. Select Add Reference Line.
3. A dialog box appears where you can configure your analytical object:

Breaking Down the Options:

• Reference Line: A single line on your chart. Most commonly used for showing an average, a company goal/target (using 'Constant'), or the minimum/maximum value.
• Reference Band: Colors a shaded area between two values. For example, you can create a band that shows the range from the minimum to the maximum sale price, or a band representing the upper and lower quartiles.
• Distribution: Shades a portion of your chart based on percentages or standard deviations. A common use is to shade the area that is +/- 1 standard deviation from the average, which quickly shows you which data points fall within the 'normal' range and which are outliers.
• Box plot: Creates a full box-and-whisker plot, showing the median, hinges (interquartile range), and whiskers. This is a very efficient way to visualize the distribution and spread of your data for different categories.

Trend Lines and Forecasts

For any data that includes a time component (like dates), trend lines and forecasts are essential for understanding historical performance and making informed guesses about the future.

Trend Lines

A trend line shows the general direction or pattern of your data over time, smoothing out the normal daily or monthly fluctuations. It helps answer the question, "Overall, are we going up, down, or staying flat?"

1. Create a view with a date dimension on one axis and a measure on the other (e.g., a line chart of sales over time).
2. Navigate to Analysis > Trend Lines > Show Trend Lines.
3. Tableau will add the best-fit line to your chart. You can further edit it by right-clicking the line and selecting Edit Trend Lines. There you can change the model from Linear to Logarithmic, Exponential, or Polynomial depending on the nature of your data pattern.

Forecasts

Tableau’s forecasting feature takes your historical time-series data and uses a statistical model (exponential smoothing) to project future values.

1. Once you have a time-series view, simply go to Analysis > Forecast > Show Forecast.
2. Tableau automatically adds the forecast to your visualization, typically showing an estimated value along with a shaded confidence interval (the range where the actual value is likely to fall).
3. You can customize this by choosing Analysis > Forecast > Forecast Options. Here you can adjust the forecast length, change the source data used, and toggle prediction intervals.

Practical Tip: Forecasts are based on patterns in your past data. If something dramatic changes in your business (like launching in a new country or your main competitor going out of business), the model won't know that. They are educated guesses, not guarantees.

Cluster Analysis

Cluster Analysis (or clustering) is a slightly more advanced feature that helps you find natural groupings within your data. Tableau uses the k-means clustering algorithm to automatically partition your data points into a specified number of clusters based on the measures you select.

A classic example is customer segmentation. Using a scatter plot of customers by their Average Order Value and Purchase Frequency, you could use clustering to automatically group them into distinct segments like 'High-Value, Frequent Shoppers,' 'Low-Value, Occasional Shoppers,' etc.

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

How to Use Clustering:

1. Create a view, typically a scatter plot, that shows individual data points (e.g., customers, products). Make sure your measures are disaggregated by unchecking Analysis > Aggregate Measures.
2. Go to the Analytics pane (next to the Data pane).
3. Drag Cluster from the Analytics pane and drop it onto the view.
4. Tableau will ask you for the variables you want to use for the clustering (they default to the measures on your canvas) and the number of clusters you want to create.

Tableau will color the marks according to their assigned cluster group, and you can then drag the 'Clusters' field (which gets added to your Dimensions) to other worksheets to further analyze the characteristics of each group.

Additional Features in the Analysis Menu

A few other handy options exist in the menu:

• Create Calculated Field: A shortcut to open the calculation editor, which is your passport to creating custom fields, formulas, and new metrics on the fly.
• Edit Calculated Field: Lets you see and modify the formula of an existing calculated field on your worksheet.
• Stack Marks: This controls how overlapping marks on an axis are displayed. The default setting of 'On' will stack them (like stacked bars). Turning it 'Off' overlays them, which can be useful when you have small marks that might get hidden in a stack.

Final Thoughts

Going beyond simple charts is what separates basic reporting from true analysis, and the Analysis menu is Tableau’s main toolkit for making that leap. By thoughtfully applying totals, reference lines, trend lines, and other analytical objects, you provide critical context that enables smarter, faster decision-making based on your data.

Mastering tools like Tableau's Analysis menu can unlock powerful business insights. We built Graphed because we believe getting those answers should be even simpler. Instead of hunting through menus and configuring dialog boxes, you can connect your scattered data sources - like Google Analytics, Shopify, and Facebook Ads - and just ask your questions in plain English. Graphed acts as your AI data analyst, instantly building the live dashboards and reports you need, so you can spend less time wrangling data and more time acting on the insights.