How to add Trend lines in Web Intelligence Graphs
It’s always been a great pleasure for anyone if you are able to resolve a challenging or a petty issue. It’s my pleasure to share the solution to one who has concerns on creating the Trend Lines in WebI Graph (Bar Chart). Interestingly, the same has been raised in Idea Place too (https://cw.sdn.sap.com/cw/ideas/1794).
Steps are as follows,
i. Pull in a vertical or horizontal “Bar and Line Chart” and display the bars using the correct measures. The chart structure and result would look like below respectively.
ii. To display a trend line [say for 98%], first create a measure variable and assign the value to be displayed.
iii. Now pull the measure (Trendline 1) in the chart to display the trend line at 98%. The chart structure and result would look like below.
iv. Modify the properties of the chart to enable/ disable the data markers and the palette color.