This is part of the SAP Lumira Discovery blog series.

The Trend line option in charts, draws a line in the plot area of the chart based on the linear difference in values of each data point. Now we can see on how to create a trend line in chart.
 

Creating Trend Lines in Chart

 
Let’s look into creating trend line in a column chart. Right click on the chart and you can find the “Add Trendline” option in the menu. Select the option, a line will be added to the chart based on difference in value between each column in the chart.
 
Trend Lines in SAP Lumira Discovery - 1
 
As you can see a line is been added in the chart.
 
Trend Lines in SAP Lumira Discovery - 2
 
We can add additional values for the trend line which enables us to forecast data.

Select ‘Edit Trendline Setting’ option in the right click menu as shown it will open a pop-up window as Trendline Setting.
 
Trend Lines in SAP Lumira Discovery - 3
 
In the pop-up window we can add the number of periods that needs to be added for the trendline in the chart. As you can see, I have given value 2
 
Trend Lines in SAP Lumira Discovery - 4
 
The output will be as shown below. The trendline will be plotted as per the value given for the forward periods. The linear aggregated values will be plotted against actual value in the chart which enables us to forecast the value for given period of values in the chart.
 
Trend Lines in SAP Lumira Discovery - 5
 
SAP Lumira Discovery only supports Linear Regression based trend lines, but can be extended multiple instances on the same chart.
 
Trend Lines in SAP Lumira Discovery - 6
 

Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

Subscribe to our Newsletter

5600 Tennyson Pkwy
Suite 120
Plano TX 75024.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com