Tableau Trend Lines - Tableau

What are Trend lines in Tableau?

Tableau facilitates in forecasting the continuation of a particular trend of a variable by using Trend lines. By observing the trend of two variables, Trend lines helps to recognize the correlation between the two variables. Trend lines are established by many mathematical models for which four options are provided by Tableau – Linear, Logarithmic, Exponential and Polynomial. This tutorial covers the linear model. One dimension and one measure are used to create Trend Lines by Tableau.

How to create Trend Line in Tableau?

The Sample-superstore is used to identify the trend for the value of the measure sales for next year by the following steps:

Step-1

The dimension Order date is dragged to the column Shelf and the measure Sales to the rows shelf. Choose the chart type as Line chart. In the Analysis menu go to model -> Trend Line. Clicking on it brings up a pop up showing different types of trend lines that can be added. Choose the linear model as shown below.

Trend Line

Step-2

On finishing the above step various trend lines appear. It also shows the mathematical expression for the correlation between the fields, the P-Value and the R-Squared value.

Trend Line 2

How to describe the Trend Line in Tableau?

The detailed description of the Trend Line is obtained by right clicking on the chart and selecting the option Describe Trend Line. It shows the coefficients, intercept value and the equation. The details thus obtained can be used for future analysis by making a copy of them on a clipboard.

Describing Trend Line

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Tableau Topics