{"id":4335,"date":"2016-12-31T03:00:09","date_gmt":"2016-12-30T19:00:09","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=4335"},"modified":"2018-09-11T18:16:56","modified_gmt":"2018-09-11T10:16:56","slug":"how-to-make-a-trendline","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/how-to-make-a-trendline.html","title":{"rendered":"How to Make A Trendline?"},"content":{"rendered":"

1. Problem description<\/strong><\/p>\n

A trendline, a great tool for data analysis<\/a>\u00a0and data visualization<\/a>, is used to display trend in data changes and is an attribute of Series. Being an important reporting tool<\/a>, it can be used in line charts, scatter charts, combination charts, column charts and area charts.The chart below is a trend chart of freights at the first half of 1997, illustrating the freight trend:
\n\"\"
\nTrendlines are set in Series format of the chart data. The example below shows how to make trendlines.
\nOpen report:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Dateaxis.cpt.<\/span>
\n2. Example<\/strong><\/p>\n

2.1 Set trendlines<\/strong>
\nSelect Chart. Click Chart Attribute Table – Style >Analysis Lines.<\/span> Click the \"\"
\nbutton under Trendline to add a trendline and set name, line style and trend style, as shown below:
\n\"\"
\nThe fitting equation of trendline is the equation type of trendline. For details, see Trendline Principle chapter.
\nThe trendline name is the name displayed in the legend.<\/p>\n

2.2 Save and preview<\/strong>
\nSave template and click Page-breaking Preview to see the effect as shown above.<\/p>\n

2.3 Forecast trendlines<\/strong>
\nTrend forecasting, belonging to\u00a0business intelligence tool<\/a>, means to predict trends ahead and after based on current trends and the unit is period, i.e., number of classifications.
\nIn the trendlines as shown above, make the trend forecast forward by 2 periods and backward by 3 periods. Then, preview the report to see the effect as follows:
\n\"\"<\/p>\n

For completed templates, see:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Trendline.cpt.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

1. Problem description A trendline, a great tool for data analysis\u00a0and data visualization, is used to display trend in data changes and is an attribute of Series. Being an important reporting tool, it can be used in line charts, scatter charts, combination charts, column charts and area charts.The chart below is a trend chart of…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[126,117],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4335"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=4335"}],"version-history":[{"count":2,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4335\/revisions"}],"predecessor-version":[{"id":4380,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4335\/revisions\/4380"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=4335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=4335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=4335"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=4335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}