[]
        
(Showing Draft Content)

Overlays

You can overlay a trendline on the chart to help viewers easily interpret a trend. A trendline, for example, helps predict future prices to understand the price movement in trade.

Add Trendlines to a Chart

  1. From the Report Explorer, expand the Chart data region node and select Plot.

  2. From the Properties inspector tab, go to Config > Overlays property.

    Overlays Configuration

  3. Click Add, corresponding to the Overlays property.

    Overlays Properties

  4. Select the trendline type in the Type property.

  5. Set the properties specific to the selected trendline, and other properties to customize color, thickness, etc.

    See the section Inspector Panel Properties.

    Inspector Panel Properties of Overlays(Trendlines)


The following types of trendlines are available:

  • Reference Line

  • Reference Band

  • Linear Trendline

  • Exponential Trendline

  • Power Trendline

  • Logarithmic Trendline

  • Polynomial Trendline

  • Fourier Trendline

  • MovingAverage Trendline

  • CumulativeMovingAverage Trendline

  • ExponentialMovingAverage Trendline

  • WeightedMovingAverage Trendline

  • MovingAnnualTotal Trendline

Inspector Panel Properties

Property

Description

Common

Name

Enter the name of the trendline.

Type

Select the type of trendline from the list of available types.

Display

Sets the display position. Select from Front or Back.

Appearance

Line Width, Style, Color

Sets the style of the line, color, and width of the trendline.

Background Color

Select the color to use for the background of the Reference Band trendline.

(Reference Band)

Configurations

Axis

Specifies the axis to which the trendline belongs. Select from X or Y.

(Reference Line, Reference Line)

Start

Specifies the start position of the Reference Band trendline.

(Reference Band)

End

Specifies the end position of the Reference Band trendline.

(Reference Band)

Value

Sets the position on the Reference Line on the specified axis.

(Reference Line)

Field

Sets the field name for the reference line to use.

(Reference Line)

Aggregate Type

Sets the reference line aggregation function. Select from Sum, Count, Average, Max, Min, Median, and Percentile.

(Reference Line)

Legend Label

Sets the legend label of the reference line.

Detail Level

Specifies if the overlay calculation should include the entire data set or each detail group. Select from Total or Group.

Intercept

Sets the intercept value of the Y-axis.

(Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline)

Forward Forecast Period

Sets the number of periods that the forecast extends forward.

(Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline)

Backward Forecast Period

Sets the number of periods that the forecast extends backward.

(Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline)

Order

Sets the number of terms in the equation. A value less than 2 is treated as 2 for the Polynomial Trendline.

(Polynomial Trendline, Fourier Trendline)

Period

Specifies the number of data values used to create a line. The default value is 2.

(MovingAverage Trendline, CumulativeMovingAverage Trendline, ExponentialMovingAverage Trendline, WeightedMovingAverage Trendline, MovingAnnualTotal Trendline)

Let us learn how to overlay trendlines on a chart, taking the 'Income Statement' report as a sample and adding trendlines to the 'Revenue vs Gross Profit' chart. You should first follow the steps in the section Add Trendlines to a Chart.

Reference Line

A Reference Line is a static line, drawn at a single point along a single axis that stretches indefinitely along the opposite axis. You can set the line's position or have it calculated by the data set. For example, you may want to add a reference line at the average value to see how each value is compared against the average.

To add the Reference Line to the chart, set up the properties as described next.

overlay-reference-line

  • Type: ReferenceLine

  • Display: Front

  • Line Width: 3pt

  • Line Color: Black

  • Line Style: Solid

  • Axis: Y

  • Field: {Revenue}

  • Aggregate Type: Average

  • Detail Level: Group

  • Legend Label: Avg. Revenue

Reference Band

A Reference Band is a shaded area, which is positioned along a single axis between two calculated values and extends indefinitely along the opposite axis. Each band has a start and end position that you set in the Properties.

This trendline is not available for Candlestick, High Low Close, and High Low Open Close type charts.

To add the Reference Band to the chart, set up the properties as described next.

overlay-reference-band

  • Type: ReferenceBand

  • Display: Back

  • Line Width: 3pt

  • Line Color: Black

  • Line Style: Solid

  • Axis: Y

  • Start: 4000

Linear Trendline

A Linear trendline creates a best fit straight line that shows how values in a data series increase or decrease at a steady rate. This trendline uses the following equation:

y = mx + b

where "m" is the slope and "b" is the intercept.

To add the Linear Trendline to the chart, set up the properties as described next.

overlay-linear-trendline

  • Type: LinearTrendline

  • Display: Front

  • Line Width: 3pt

  • Line Style: Solid

  • Line Color: Black

  • Intercept:1

  • Forward Forecast Period: 0

  • Backward Forecast Period: 0

  • Field: {Revenue}

  • Legend Label: Avg. Revenue

  • Detail Level: Total

Exponential Trendline

An Exponential trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. You can use this trendline only with positive numbers. If the data series contains any zero or negative numbers, then this trendline is not available. This trendline uses the following equation:

y = cebx

where "c" and "b" are constants, and "e" is the base of the natural logarithm.

To add the Exponential trendline to the chart, set up the properties similar to the Linear Trendline, with the Type property 'ExponentialTrendline'.

overlay-exponential

Power Trendline

A Power trendline creates a curved line to compare measurements that increase at a specific rate. You can use this trendline only with positive numbers. If the data series contains any zero or negative numbers, then this trendline is not available.

This trendline uses the following equation:

y = axb

where "a" and "b" are constants.

To add the Power trendline to the chart, set up the properties similar to the Linear Trendline, with the Type property 'PowerTrendline'.

overlay-power

Logarithmic Trendline

A Logarithmic trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. This trendline uses the following equation:

y = c ln(x) + b

where "c" and "b" are constants, and "ln" is the natural logarithm function.

To add the Logarithmic trendline to the chart, set up the properties similar to the Linear Trendline, with the Type property 'LogarithmicTrendline'.

Polynomial Trendline

A Polynomial trendline creates a curved line, illustrating fluctuations in the data values. The trendline uses the following equation:

y = b + c1x + c2x2 + c3x3 + ...

where c1, c2, c3 are constants.

To add the Polynomial trendline to the chart, set up the properties similar to the Linear Trendline, with the Type property 'Polynomial Trendline' and Order value ranging from '2' to '6'.

Fourier Trendline

A Fourier trendline creates a trendline, based on the Fourier Series. It identifies patterns or cycles in a series data set, and removes the effects of trends or other complicating factors from the data set, thereby providing a good estimate of the direction that the data under analysis will take in the future.

y = C0 + C1 cos(x) + C2 sin(x) + C3 cos(2x) + C4 sin(2x) + ...

To add the FourierTrendline trendline to the chart, set up the properties similar to the Linear Trendline, with the Type property 'FourierTrendline' and Order value ranging from '2' to '6'.

MovingAverage Trendline

A MovingAverage trendline reduces the fluctuations in the trendline to show a smoother pattern. This trendline uses the following equation:

Ft = (At + At-1 + At-2 ) / n

To add the MovingAverage trendline to the chart, set the Type property to 'MovingAverage' and Period to a value that you want to specify as data points.

CumulativeMovingAverage Trendline

In a CumulativeMovingAverage trendline, the data arrive in an ordered datum stream, and you get the average of all data up until the current datum point.

To add the CumulativeMovingAverage trendline to the chart, set the Type property to 'CumulativeMovingAverage ' and Period to a value that you want to specify as data points.

ExponentialMovingAverage Trendline

An ExponentialMovingAverage (EMA), also known as an exponentially weighted moving average (EWMA), is a first-order infinite impulse response filter that applies weighting factors, which decrease exponentially. The weighting for each older datum decreases exponentially, never reaching zero.

To add the ExponentialMovingAverage trendline to the chart, set the Type property to 'ExponentialMovingAverage ' and Period to a value that you want to specify as data points.

WeightedMovingAverage trendline

A WeightedMovingAverage trendline is an average that has multiplying factors to give different weights to data at different positions. Mathematically, the moving average is the convolution of the datum points with a fixed weighting function.

To add the WeightedMovingAverage trendline to the chart, set the Type property to 'WeightedMovingAverage' and Period to a value that you want to specify as data points.

MovingAnnualTotal trendline

A MovingAnnualTotal trendline is a moving total of the prior 'n' points at an abstract level.

To add the MovingAnnualTotal trendline to the chart, set the Type property to 'MovingAverageTotal' and Period to a value that you want to specify as data points.