Trend Lines are additional lines that are added in a scenario to display trends in the data. They help in data forecasting and planning by predicting future values based on the current data values. The trend lines are useful in grabbing the user's attention to a specific area within the data series.
The trend lines supported in Wyn Enterprise are described as follows.
y = mx + b
y = b + (c1 * x) + (c2 * (x ^ 2)) + (c3 * (x ^ 3)) + ..
y = m * ln (X) + c
y = c * x ^ b
y = c * e ^ (b * x)
Note: In Wyn Enterprise, trend lines are supported in a variety of charts such as bar, column, area, line, scatter, and bubble. You cannot add a trend line to stacked percent charts, pie, radar, and similar charts.
Select the dashboard scenario for which you want to add a trend line. Note that an Action Bar automatically appears on the right of the scenario.
From the Action Bar, select Trend Line.
In the Trend Line dialog that appears, select a suitable type for the trend line depending on your data. For example, select 'Polynomial' and set its Degree to '3'. By default, the degree is set to 2.
Specify the line style for the trend line. You can set Line Style to 'Solid' (default) or change it to 'Dashed'.
Set the Scope for the trend line to either 'Total' or 'Group'. That is, specify if the trend line is calculated for the total data set or per detail group.
Customize the trend line appearance by setting the Line Width and Line Color to some suitable values. For example, set the line width to '3' and line color to 'Yellow' from the color picker.
Click Apply and then OK to save the changes.