{"id":3588,"date":"2016-06-23T03:00:35","date_gmt":"2016-06-22T19:00:35","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3588"},"modified":"2018-09-11T18:50:31","modified_gmt":"2018-09-11T10:50:31","slug":"data-source-of-dataset","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/23\/data-source-of-dataset\/","title":{"rendered":"Two Kinds of Data Source of Dataset."},"content":{"rendered":"

We have learned how to make chart. As we know, chart data in data visualization<\/a> can be directly from data set and from cell data.<\/p>\n

Then, for chart, how to bind data set or the data field chart in the cell or how to display the data in data set.<\/p>\n

The chart defines chart data by binding the fields in data set or cells to the category axis, Series name and Series value of chart.<\/p>\n

We will give a detailed introduction about different data sources and setting methods of chart data about FineReport reporting tool<\/span><\/a>.<\/p>\n

Field Name as SeriesValue<\/h3>\n

1. Description<\/strong>
\nIf chart data can be directly extracted from dataset and chart’s seriesname is field name, chart series value corresponds to field value, we can define chart through “data source of dataset-field name as SeriesValue”.<\/p>\n

Like the regional salesvolume chart:<\/p>\n

\"\"<\/p>\n

2.Chart Data Source<\/strong><\/p>\n

Chart data comes from dataset
\n\"\"
\nAs known from desired effect<\/p>\n\n\n\n\n\n
Category axis<\/td>\nArea<\/td>\nArea field<\/td>\n<\/tr>\n
Series name<\/td>\nSales volume<\/td>\nSales volume field name<\/td>\n<\/tr>\n
Series value<\/td>\nSales volume value<\/td>\nSales volume field value and SUM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3.Define Chart Data<\/strong><\/p>\n

After affirming Category, SeriesName and SeriesValue, now we set chart data source as shown below:
\n\"\"<\/p>\n

Field Value as SeriesValue<\/h3>\n

1.Description<\/strong><\/p>\n

If chart data can be directly extracted from dataset and chart’s seriesname comes from one data column, we can define chart through “data source of dataset-field value” as SeriesValue like the template Chart.cpt made in chapter \u201cIntroduction\u2014Chart Making Procedure\u201d.
\n\"\"<\/p>\n

2.Chart Data Source<\/strong><\/p>\n

Chart data comes from dataset and seriesname is field value.<\/p>\n

\"\"<\/p>\n

As known from desired effect<\/p>\n\n\n\n\n\n
Category axis<\/td>\nArea<\/td>\nArea field<\/td>\n<\/tr>\n
Series name<\/td>\nProduct name<\/td>\nProduct type field<\/td>\n<\/tr>\n
Series value<\/td>\nSales volume value<\/td>\nSales volume fields and SUM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3.Define Chart Data<\/strong><\/p>\n

After affirming Category, SeriesName and SeriesValue, now we set chart data source as shown below:
\n\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

We have learned how to make chart. As we know, chart da…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3588"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3588"}],"version-history":[{"count":14,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3588\/revisions"}],"predecessor-version":[{"id":4224,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3588\/revisions\/4224"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}