How to Create a Trend Report in Tableau

Tracking performance over time is fundamental to understanding what’s working in your business. A trend report helps you cut through the noise, showing you the bigger picture of your growth, seasonality, and the impact of your efforts. This guide will walk you through exactly how to create a clear and insightful trend report in Tableau, step by step.

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 Exactly Is a Trend Report?

A trend report, at its core, is a simple visualization that shows you how a specific metric changes over a period of time. Instead of looking at a single number, like "we made $10,000 in sales," a trend report shows you the journey - how you got there and where you might be going next. It's the difference between a snapshot and a story.

By plotting your data over days, weeks, months, or years, you can instantly spot:

• Patterns: Can you see sales dipping at the end of every quarter? Or a spike in website traffic every Monday morning?
• Growth or Decline: Is your user base steadily increasing, or has growth started to slow down?
• Seasonality: Does your e-commerce revenue predictably skyrocket in November and December?
• Impact of Events: Can you see a clear lift in new sign-ups after launching a major marketing campaign?

These reports are incredibly versatile, used by marketing teams to monitor campaign performance, sales teams to track monthly targets, and founders to get a high-level view of business health. The line chart is the classic choice for trend analysis because of its ability to clearly show movement and direction over a continuous period.

Getting Your Data Ready

Before you jump into Tableau, a quick check of your data source will save you a lot of headaches. For any time-based analysis, the single most important thing is having a clean, consistent date field. Without it, Tableau won't know how to plot your data over time.

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

Check for a Clear Date Column

Your spreadsheet or database table should have a dedicated column that contains dates. It sounds obvious, but it's a common stumbling block. This column should be formatted as a date (e.g., 01/15/2024 or 2024-01-15), not as plain text. When Tableau connects to your data, it will automatically recognize properly formatted date fields and assign them a small calendar icon.

If your dates look like “Jan 2024” or “Q1 2024,” Tableau might interpret them as text strings. You can often fix this directly within Tableau by right-clicking the field, selecting "Change Data Type," and choosing "Date" or "Date & Time."

How to Create a Trend Report in Tableau: Step-by-Step

Let's build a classic sales trend report. For this example, imagine we have a simple sales dataset with columns for Order Date, Sales, and Product Category.

Step 1: Connect to Your Data

First, open Tableau and connect to your data source. This could be an Excel file, a Google Sheet, a CSV, or a direct connection to a database. Once connected, Tableau previews your data on the "Data Source" page. If everything looks right, click on "Sheet 1" at the bottom to go to your worksheet.

Step 2: Add Your Date to the View

The foundation of any trend report is time. In Tableau, you establish your timeline by dragging your date field onto the Columns shelf at the top of the worksheet.

1. Locate your date field (e.g., Order Date) in the Data pane on the left-hand side.
2. Click and drag Order Date onto the Columns shelf.

Tableau will likely aggregate your date to the highest level, which is typically YEAR(Order Date). This creates a column in your chart for each year in your dataset.

Step 3: Adjust the Date Granularity

Seeing your data by year is a start, but it's not very detailed. You’ll usually want a more granular view to see the actual trends. This is where Tableau's date functionality really shines.

Right-click the blue YEAR(Order Date) pill on the Columns shelf. You'll see two sections in the context menu. The top section (Year, Quarter, Month, etc.) contains discrete date parts, while the bottom section contains continuous date values.

• Discrete (Blue Pill): This breaks your dates into distinct parts. Choosing "Month" from the top section will give you every "January," "February," etc., grouped together, regardless of the year. This is great for comparing seasonality (e.g., how every January performs).
• Continuous (Green Pill): This treats your timeline as a smooth, unbroken axis. Choosing "Month" from the bottom section will create an axis showing Jan 2023, Feb 2023, Mar 2023, and so on. For trend reports, a continuous date is almost always what you want.

For our report, right-click the date pill and select the second Month option from the dropdown menu (the one with the small line chart icon). Your horizontal axis should now show a continuous timeline of months and years.

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 4: Add Your Measure to the View

Now that your timeline is set, it's time to plot your key metric. This is whatever you want to measure over time, such as sales, website sessions, new users, or support tickets.

1. Find your measure (e.g., Sales) in the Data pane. Measures are usually numeric fields.
2. Click and drag Sales onto the Rows shelf.

And just like that, you have a line chart! Tableau automatically generates a line showing the total sales for each point in time along your axis. You've officially created a trend report.

Enhancing Your Report for Deeper Insights

A basic line chart is good, but you can layer on more information to make your report even more valuable.

Compare Trends Across Different Categories

What if you want to see how different product categories are trending against each other? This is easy to do by using the Color property on the Marks card.

1. Find the dimension you want to segment by (e.g., Product Category).
2. Drag it and drop it directly onto the Color box in the Marks card.

Tableau instantly splits your single line into multiple colored lines - one for each product category. A color legend appears on the right, helping you decipher which line is which. This is one of the quickest ways to uncover insights, as you can immediately spot which categories are driving growth and which are lagging.

Add a Trend Line

To see the overall direction of your data and smooth out the monthly fluctuations, add a trend line. This is a statistical line that shows the general slope of your data.

1. Go to the Analytics pane (it’s next to the Data pane on the left).
2. Click and drag Trend Line from the pane and drop it onto your chart. A set of options will appear, just drop it on Linear.

Tableau adds a dotted line that shows the general upward or downward movement of your sales over the specified period, giving you a quick visual cue about your overall momentum.

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

Go Deeper with a Dual-Axis Chart

Sometimes you need to compare two different metrics that have different scales, like Sales (measured in dollars) and Profit (also measured in dollars), or Website Visitors and Conversion Rate. A dual-axis chart is perfect for this.

Let's say you want to compare your Sales trend with your Profit trend.

1. Start with your basic sales trend report (Order Date on Columns, Sales on Rows).
2. Drag your second measure (e.g., Profit) and drop it on the Rows shelf, to the right of your first measure. You will now have two separate line charts, one above the other.
3. Right-click the second pill on the Rows shelf (the Profit pill) and select Dual Axis from the menu.

The two charts will merge into one, with two different Y-axes (one on the left, one on the right). This allows you to see the relationship between the two metrics' trends directly, even if their values are on completely different scales.

Final Touches for a Professional Report

• Give Your Sheet a Title: Double-click the sheet title (e.g., "Sheet 1") and name it something descriptive, like "Monthly Sales Trend by Product Category."
• Clean Up Tooltips: Hover over a data point on your line. The box that appears is the tooltip. You can click the Tooltip box on the Marks card to edit what information appears there for a cleaner experience for your audience.
• Use Annotations: If you know a big product launch or marketing campaign happened on a certain date, you can add context. Right-click on a data point on the chart, go to "Annotate," and choose "Mark." This lets you add a text box explaining why there might be a spike or dip in your performance.

Final Thoughts

Creating a trend report in Tableau is a foundational skill that unlocks incredible insight into your business performance. By placing time on one axis and your key metric on another, you transform a static dataset into a dynamic story, revealing patterns and momentum that would otherwise remain hidden in rows of numbers.

While mastering a tool like Tableau is definitely a valuable skill for any analyst, sometimes you need insights without the learning curve or manual setup. For those moments, Graphed provides a faster way forward. Instead of dragging and dropping pills, we let you create real-time trend reports and dashboards just by describing what you want to see. You can connect sources like Google Analytics or your CRM in one click and ask, "Show me my sales from Shopify by month for the last year," to get an interactive chart in seconds.