EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Trend Lines in Tableau

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Trend Lines in Tableau

Trend Lines in Tableau

Introduction to Trend Lines in Tableau

Trends provides important insights into the analysis, it highlights trends in data. Tableau creates trend lines with dimensions and measures field. To add trend lines in data both axis must contain numbers (columns and rows). Tableau will not create a trend line for dimension named city or country 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.

Popular Course in this category
Tableau Training (4 Courses, 6+ Projects)4 Online Courses | 6 Hands-on Projects | 39+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (6,121 ratings)
Course Price

View Course

Related Courses
Business Intelligence Training (12 Courses, 6+ Projects)Data Visualization Training (15 Courses, 5+ Projects)
  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
  5. Tableau Context Filter

Tableau Training (4 Courses, 6+ Projects)

4 Online Courses

6 Hands-on Projects

39+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Tableau Tutorial
  • Charts
    • Tableau Charts
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Tableau Date Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Reporting
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • 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

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

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

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

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

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

Special Offer - Tableau Training (4 Courses, 6+ Projects) Learn More