Wyn Enterprise: Trend Line

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.

Type	Description
Linear	It is a straight line that is used to determine how the data values are increasing or decreasing at a steady rate. It uses the following linear equation to compute the least squares, that is, y = mx + b where m is the slope and b is the intercept.
Polynomial	It is a curved line that is used to show fluctuations in the data values. It uses the following equation to compute the least squares, that is, y = b + (c1 * x) + (c2 * (x ^ 2)) + (c3 * (x ^ 3)) + .. where c1, c2, and c3 are the constants. Use the Degree property to specify the number of terms in the polynomial equation - the range for the degree is from 2 to 6.
Logarithmic	It is a curved line used to plot the data that increases or decreases quickly, and then levels out. It uses the following equation to compute the least squares, that is, y = m * ln (X) + c where m and c are the constants and ln is the natural logarithm function.
Power	It is a curved line that is used to compare the measurements increasing at a specific rate. It uses the following equation to compute the least squares, that is, y = c * x ^ b where c and b are the constants. Note that you cannot use the power trend line with zero or negative values.
Exponential	It is a curved line that shows data values with relatively higher rates of rising or falling. It uses the following equation to compute the least squares, that is, y = c * e ^ (b * x) where c and b are the constants and e is the natural logarithm. Note that you cannot use the exponential trend line with zero or negative values.
Fourier	It is a trend line based on the Fourier series, , where T = '2 π' and . Use the Degree property to specify the number of terms in the Fourier Equation, ranging from 1 to 6.

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.

Add a Trend Line

1. 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.

2. From the Action Bar, select Trend Line.

   

3. 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.

   

4. Specify the line style for the trend line. You can set Line Style to 'Solid' (default) or change it to 'Dashed'.

5. 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.

6. 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.

   

7. Click Apply and then OK to save the changes.