{"id":4352,"date":"2017-01-05T03:00:50","date_gmt":"2017-01-04T19:00:50","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=4352"},"modified":"2018-09-11T17:18:19","modified_gmt":"2018-09-11T09:18:19","slug":"how-to-make-a-functional-dynamic-chart-data","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/how-to-make-a-functional-dynamic-chart-data.html","title":{"rendered":"How to Make a Functional Dynamic Chart Data?"},"content":{"rendered":"

1. Function description<\/h3>\n

Sometimes, the user wants to display different charts based on different conditions, as shown below. Select Year and Month condition, and the chart, as a great reporting tool<\/a>, will display data meeting certain conditions so as to realize dynamic chart:
\n\"\"<\/p>\n

2. Realization ideasEdit<\/h3>\n

Dynamically change chart data source based on parameter conditions.
\nIf the chart data is from dataset, you can dynamically change chart data through data source parameters.
\nIf the chart data is from cell, you can change chart data through report parameter and filter setting, which will serve as an example in this section.<\/p>\n

3. Example<\/h3>\n

3.1 Prepare data<\/strong>
\nCreate a new workbook and add dataset ds1, with SQL statement of SELECT strftime(‘%Y’, ordering date) as year, strftime(‘%m’, ordering date) as month, shipper\u2019s province, payable FROM [order]<\/span>.
\n3.2 Define parameters<\/strong>
\nWe will dynamically change the chart based on selected year and month. Define the 3 report parameters below:
\nReport parameter Year: year. Default value: 2010;
\nReport parameter Start: start month. Default value: 1;
\nReport parameter End: end month. Default value: 6.
\nThe Parameter Interface is designed as follows:
\n\"\"<\/p>\n

\"\"
\n\"\"\"\"<\/p>\n

 <\/p>\n

3.3 Make a sample table<\/strong>
\nIn the cell, calculate and summarize the sales volumes of several months in a year for different provinces, as shown below:
\n\"\"
\nSet the data column as below:
\n\"\"
\nBased on parameter values, the data calculated in the cell are different. When cell is used as the data source, the chart also displays different data so as to realize dynamic chart, a good business intelligence tool<\/a>, and help\u00a0data analysis<\/a> and\u00a0data visualization<\/a>.
\n3.4 Insert chart<\/strong>
\nMerge a group of cells, as shown above. Right click Cell Element > Insert Chart<\/span>. Select Column Chart and click OK.
\n3.5 Set chart type<\/strong>
\nSet Column Chart Type to 3D Column Chart, as shown below:
\n\"\"
\n3.6 Set chart data<\/strong>
\nThe chart data is from the cell. The data category axis is Region; Series name is Month; and Series Value is Sales Volume, as shown below:
\n\"\"
\nClick Save to complete a dynamic chart that can be changed with parameter change.
\n3.7 Set dynamic title<\/strong>
\nSet a dynamic title for the chart. Select Chart and select Chart Attribute Table – Style> Title<\/span>. Click formula button, where the formula is =$Year+” year “+$Start+”\u2014”+$End+” “. Display dynamic title based on different parameters.
\n\"\"
\nFinal template style in the main body of report is as shown below:
\n\"\"
\n3.8 Save and preview<\/strong>
\nSave template and click Page-breaking Preview to see the effect as shown above.
\n\"\"
\nFor completed templates, see:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Dynamic.cpt<\/span>\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

1. Function description Sometimes, the user wants to display different charts based on different conditions, as shown below. Select Year and Month condition, and the chart, as a great reporting tool, will display data meeting certain conditions so as to realize dynamic chart: 2. Realization ideasEdit Dynamically change chart data source based on parameter conditions….<\/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":[569,1675,586,2595,568],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4352"}],"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=4352"}],"version-history":[{"count":4,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4352\/revisions"}],"predecessor-version":[{"id":4612,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4352\/revisions\/4612"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=4352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=4352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=4352"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=4352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}