EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Trend Lines in Tableau

Trend Lines in Tableau

By Priya PedamkarPriya Pedamkar

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.

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

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

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
WINDOWS POWERSHELL Certification Course
26+ Hours of HD Videos
7 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
SALESFORCE Training
34+ Hours of HD Videos
4 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MINITAB Data Science & Statistics
48+ Hours of HD Videos
9 Courses
2 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
SAS PROGRAMMING for Statistics & Data Analysis Course
161+ Hours of HD Videos
18 Courses
8 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
TABLEAU Data Analyst & Specialist Desktop Certification
 69+ Hour of HD Videos
16 Courses
2 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - 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

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
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*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?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Hurry! - Any Learning Path @ $19 | OFFER ENDING IN ENROLL NOW