How to Use Quick Analysis in Tableau

Working with data in Tableau sometimes feels like you’re doing detective work, looking for insights hidden within your charts and graphs. The Quick Analysis tool is your magnifying glass, letting you instantly perform common analytical tasks like adding reference lines, trend lines, and filters without ever leaving your visualization. This article will show you exactly how to use this feature to speed up your workflow and uncover insights much faster.

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 Quick Analysis in Tableau?

Quick Analysis is a feature that appears when you select one or more data points (marks) directly in your view. It provides a small, contextual menu - often identified by a lightning bolt icon - that gives you one-click access to some of Tableau's most useful analytical functions.

Instead of navigating to the Analytics pane or creating a complex calculation, you can immediately:

• Add reference lines to see averages, totals, or medians.
• Apply trend lines to understand patterns over time.
• Filter data to either keep or exclude specific points.
• Create groups on the fly to combine related categories.
• Generate forecasts to project future performance.

The beauty of Quick Analysis is its speed and convenience. It keeps you in the flow of your analysis, allowing you to ask and answer follow-up questions about your data as they pop into your head.

Where to Find and How to Activate Quick Analysis

Accessing the Quick Analysis menu is straightforward. The key is that you must first have a visualization and then select one or more marks on it. There are two primary ways to do this.

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. Selecting a Single Mark

This is the most common method. Simply click on a single data point in your view, like a bar on a bar chart, a point on a scatter plot, or a section on a map. When you do, a tooltip will pop up with details about that mark. Here, you'll find a set of small icons, including the Quick Analysis lightning bolt icon.

Example: You create a bar chart showing Sales by Product Category. Clicking on the 'Technology' bar will reveal its tooltip along with the Quick Analysis menu.

2. Selecting Multiple Marks

To analyze multiple data points at once, you can select them together. Click and drag your mouse to draw a box around the marks you want to include. Alternatively, you can hold down the Ctrl key (Cmd on Mac) and click on individual marks to add them to your selection.

Once you've selected multiple marks, hover your mouse over any of the selected points. The tooltip will appear, summarizing the data for your entire selection (e.g., "3 items selected") and showing the same set of icons, including Quick Analysis.

Exploring the Quick Analysis Tools Step-by-Step

Let's dive into the most common analytical operations available through Quick Analysis and see how to use them with practical examples.

Applying Reference Lines and Bands

Reference lines are perfect for adding context to a chart. They help you instantly compare performance against a standard, such as an average, a target, or a previous period.

• What it is: A constant or computed line drawn across a numeric axis to provide a point of reference.
• When to use it: When you want to see if your monthly sales are above or below the quarterly average, or how different regions perform relative to the overall company average.

How to Add an Average Line:

1. Create a view, such as a bar chart of Sales by Month.
2. Click on any bar in the chart to select it. The tooltip with the Quick Analysis icon will appear.
3. Click the lightning bolt icon to open the menu.
4. Select Average Line. Tableau will immediately calculate the average of all the bars on your chart and draw a reference line, labeling it "Average."

Just like that, you have a valuable benchmark added to your view without digging through any menus. You can use the same process for Median, Totals, Minimums, and Maximums.

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

Displaying Trend Lines

Trend lines help you visualize the general direction of your data over time, making it easy to spot upward or downward trends that might not be obvious at first glance.

• What it is: A line that represents the "best fit" for your data points, showing momentum and patterns.
• When to use it: For any time-series data, like tracking monthly website traffic, quarterly revenue, or daily customer inquiries.

How to Add a Trend Line:

1. Build a line chart showing a measure over time, such as SUM(Sales) by continuous MONTH(Order Date).
2. Click anywhere on the line to see the tooltip.
3. Click the lightning bolt icon and select Trend Line.

Tableau instantly adds an overlay to the chart, indicating the overall direction of sales. If you hover over the trend line, you can see the statistical details like the R-Squared and p-value, helping you understand how well the line fits the data.

Quick Filtering (Keep Only or Exclude)

Often during analysis, outliers can skew your view, or you might want to isolate a specific segment to analyze it further. Quick filters let you do this instantly.

• What it is: A fast way to include or exclude data points directly from the view.
• When to use it: You spot an extreme outlier in sales that's distorting your chart's axis and want to remove it temporarily. Or, you identify several top-performing states and want to focus your analysis solely on them.

How to "Keep Only" Top Performers:

1. Imagine a map view showing Profit by State.
2. Hold down the Ctrl key (Cmd on Mac) and click on your three most profitable states (e.g., California, New York, Washington).
3. Hover over one of the selected states to bring up the tooltip menu.
4. Click the filter icon and choose Keep Only.

The entire view will update to only show data for those three states, allowing you to drill down into their performance without having to create a separate filter control.

Creating Groups On-the-Fly

Grouping allows you to combine multiple members of a dimension into a single category, which is useful for simplifying views or analyzing aggregates.

• What it is: Combining multiple marks to create a new dimension member.
• When to use it: On a scatter plot of products, you might group several low-selling items into a "Discontinue?" category. Or on a bar chart of all your marketing channels, you could group smaller ones into an "Other" category.

How to Create a Group:

1. Build a scatter plot with Sales on one axis and Profit on the other, with Product Name on Detail.
2. Drag your mouse to highlight a cluster of products in the low-profit, low-sales quadrant.
3. Hover over the selection to bring up the tooltip.
4. Click the paperclip icon (Group Members).
5. A dialog will appear where you can name your new group. Name it "Underperforming Products." This new group is now available as a dimension in your Data pane for later use.

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

Practical Walkthrough: Bringing It All Together

Let's walk through a common analysis scenario to see how these Quick Analysis tools work together.

Goal: Analyze monthly product sales to identify low-performing months and understand the overall yearly trend.

1. Build the Base Chart: Create a bar chart showing SUM(Sales) by MONTH(Order Date). You have 12 bars, one for each month.
2. Add a Benchmark: You want to see which months fell below average. Click any bar, hit the lightning bolt, and select Average Line. You can now instantly see the months that underperformed.
3. Investigate an Outlier: Let's say November's sales were unusually high, maybe due to a holiday promotion. To see how the trend looks without this spike, click the November bar, select the tooltip filter icon, and choose Exclude. The view updates, resizing the axes and recalculating the average line based on the remaining data.
4. Check the Overall Trend: Click anywhere on the chart, click the lightning bolt, and select Trend Line. This adds a trend line based on your (now filtered) data, giving you a more accurate picture of normal monthly growth.

In just four clicks, you performed a nuanced analysis that would have otherwise required navigating through multiple panes and menus. You quickly established a baseline, isolated an outlier for deeper review, and visualized the underlying performance trend.

Final Thoughts

Tableau's Quick Analysis feature is a quiet but powerful accelerator for anyone doing exploratory data analysis. By embedding common analytical functions right into your visualization, it keeps you in the creative flow, helping you uncover meaningful insights without interruption and manual configuration.

While mastering tools like Tableau is empowering, we built Graphed for teams who'd rather skip the learning curve and manual work altogether. Instead of building charts and finding menus, you can simply connect your data sources - like Google Analytics, Shopify, or Salesforce - and ask questions in plain English. For example, you can say, "Show me a dashboard of my monthly sales trends compared to the yearly average," and we instantly generate the live, interactive visualization for you, getting you from question to insight in seconds.