Adding a Trend Line

Contents[Hide]

1. Overview

A trend line is a straight line that connects two or more points and then extends into the future to act as a line of best fit or regression line.

Prior to version 3.0, to add a trend line, you need to add a line chart to an existing chart using the Trend and Forecasting function. Starting in version 3.0, to add a trend line, you can right click on your existing chart (either in edit or view mode), and select the new "Add Trend Line" option.

2. Data preparation

Sample data: Stock (monthly average) closing value as measure and date as hierarchy.

Sample monthly data - partial data shown
Sample monthly data - partial data shown

Data when viewed as a chart (e.g. using a Curved Line chart):

Using a curved line chart
Using a curved line chart

3. Add a Trend Line

  1. In the dashboard editor, or while viewing the dashboard, right-click on the data visualization and select "Re-Visualize"

    Right click -> Revisualize
    Right click -> Revisualize

  2. Select "Add Trend Line"

    Edit mode - Add a Trend Line
    Edit mode - Add a Trend Line

Result:

Curved Line Chart with a Trend Line
Curved Line Chart with a Trend Line

4. Data Analysis Panel

If you check the Data Analysis Panel, you will notice that one additional measure representing the trend line was created.

Data Analysis Panel
Data Analysis Panel

 

The formula generated uses the Trend and Forecasting function:

Formula bar
Formula bar

5. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri