EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials Tableau Tutorial Trend Lines in Tableau
 

Trend Lines in Tableau

Priya Pedamkar
Article byPriya Pedamkar

Updated March 22, 2023

Trend Lines in Tableau

 

 

Introduction to Trend Lines in Tableau

Trends provide important insights into the analysis; it highlights trends in data. Tableau creates trend lines with dimensions and measures fields. To add trend lines in data, both axis must contain numbers (columns and rows). For example, tableau will not create a trend line for city or country dimension because it does not contain numbers.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Mathematical models are used for creating trend lines. Tableau provides for five trend line options – 1. Linear 2.  Logarithmic 3. Exponential 4. Polynomial 5.  Power

With the help of trend lines, we can see the trend present in data. We can highlight trends in the data we have. Because of the tableau, we can publish a view that contains trend lines or share a view that has trend lines to others.

How to create a Trend Line in tableau?

Below are the steps for setting up a trend line in tableau.

  1. Open tableau application.
  2. Open data source.
  3. Drag the order table into the workbook.

Trend Line in tableau 1

  1. Go to the worksheet.
  2. Drag Order date (dimension) and Discount (measure) into columns and rows.

Trend Line in tableau 2

  1. Go to the Analytics pane, select Trend Line and drag it overview created.
  2. Select the Linear trend line.

Trend Line in tableau 3

  1. The view will change once the trend line is selected.

Trend Line in tableau 4

  1. We can see a description of the trend line created.

Trend Line in tableau 5

  1. Drag ship date dimension to columns and profit measure to rows.
  2. Go to the analytics pane and select the trend line.
  3. Drag trend line overview and select the Exponential trend line.

Trend Line in tableau 6

  1. The result will change once the trend line dragged.
  2. Hover over the trend line, we can see the description of the trend line.

Trend Line in tableau 7

  1. Drag ship date (dimension) to columns and sales (measure) to rows.
  2. Go to analytics pane and select the trend line.
  3. Drag trend line overview and select the polynomial trend line.

Trend Line in tableau 8

  1. Once the trend line dragged view will change and we can see the description of the trend line.

Trend Line in tableau 9

  1. We will draw the Logarithmic trend line.
  2. Drag order date (dimension) into columns.
  3. Drag sales (dimension) into columns.
  4. Drag discount (measure) into rows.
  5. Go to analytics pane and select Trend Line.
  6. Drag trend line as Logarithmic to view.

You will see the following image.

Trend Line in tableau 10

  1. Drag regions into colors.

Drag regions into colors

  1. We will draw the Power trend line.
  2. Drag ship date (dimension) to columns.
  3. Drag profit (measure) to columns.
  4. Drag sales (measure) to rows.
  5. Go to analytics pane, select trend line and drag it to view.
  6. Drag trend line to power as a trend line.

Trend Line in tableau 11

Trend Line in tableau 12

How does Trend Line Work?

Trend lines used for predicting statistical analysis of the data. Let’s say that it takes a reference to the linear model we have created. We can see in that example of how discount has increased each year. By calculating the discount, we can get a figure of profit we made in each year. We can calculate statistics of numbers with the help of trend lines. We don’t need to perform any calculations, it is inbuild in tableau. We only need to drag the appropriate field to get insight into the data.

Look at the below image to get profit made each year by applying a discount.

Trend Line in tableau 13

applying a discount

Observing the above example we can understand that if we start visualizing data, we will get random plots. Trend lines help us to plot the data with the fitting best curve or straight lines.

One number field should be present on columns shelf and one numeric field on the shelf.

Trend lines provide details of each plotting.

a) Select the trend line and click on describe trend line.

Select the trend line

b) We will get below the image when we click on the describe trend line.

describe trend line

  • To estimate the linear relationship, linear trend lines are the best example. They have the following form of the equation. Y= b0+b1X
  • When the rate of change increases or decreases between variables, we can use the logarithmic trend line. In the above example, we can observe how the rate of change (discount) affected.
  • When the rate of change increases rapidly between variables, we can use the exponential trend line. In the above example, we can see how profit changes for each region.
  • Curve lines are nothing but the polynomial trend line when the rate of change is fluctuating.
  • Power trend line uses the natural log for transforming variables, it does not accept value less than zero because logarithm is not made for zero value. In the above example, we can observe that.

Edit Trend Lines

Let us see how pre and post editing in trend line works.

  1. Click on the trend line.
  2. Select the edit trend line. A new dialog box will open.
  3. We can edit it as we want, we have selected Region only. The graph will change.

Before editing

Before editing

 After Editing

 After Editing 1

 After Editing 2

DashBoard

We have created a dashboard with all types of linear models. We have unhide some of the header files. Drag and Drop all the worksheets into the dashboard and visualize it as you want.

dashboard

Describe Trend Model

This feature of tableau will show us how the formula is calculated for the model.

  • Click on the trend line.
  • Select describe trend line. You will see the below image.

Describe Trend Model

Conclusion

We have learned what trend lines are, how to use it and when to use which trend line model.

If a person is not familiar with math i.e. statistics, that person does not need to worry about how the trend line is calculated or how the formula is applied. We only need to know which data field we want to do analysis with.

Recommended Articles

This is a guide to Trend Lines in Tableau. Here we discuss steps for setting up a trend line in tableau and how trend line editing works in both pre and post. You may also look at the following article to learn more –

  1. Tableau Dashboard Creation
  2. Parameters in Tableau
  3. Forecast in Tableau
  4. Pivot in Tableau

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW