{"id":4354,"date":"2017-01-05T03:00:08","date_gmt":"2017-01-04T19:00:08","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=4354"},"modified":"2018-09-11T17:18:25","modified_gmt":"2018-09-11T09:18:25","slug":"do-you-know-the-magic-of-single-series-category-chart-sorting-how-to-make-it","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/do-you-know-the-magic-of-single-series-category-chart-sorting-how-to-make-it.html","title":{"rendered":"Do You Know the Magic of Single Series (Category) Chart Sorting? How to Make it?"},"content":{"rendered":"

1. Problem description<\/h3>\n

In using a chart, it is able to display by data size. Take a column chart as an example, how to allow all columns to be sorted by data size from high to low or vice versa for better data analysis<\/a>, as shown below?
\n\"\"<\/p>\n

2. Realization ideas<\/h3>\n

The chart, a good reporting tool<\/a> and business intelligence tool<\/a>, is sorted and displayed based on series by default.
\nIf the chart data source comes from a single dataset, it is possible to sort directly using Sort In The Data Set<\/span>, and set the chart data source as dataset data; if the chart data source is calculated by cell, it is possible to sort by using Sort After Extension<\/span> and set the chart data source as cell data.<\/p>\n

3. Example<\/h3>\n

Here is a simple example to show how to realize the effect as shown above so as to achieve data visualization<\/a>.<\/p>\n

3.1 Dataset data as chart data source<\/strong><\/p>\n

3.1.1 Open template<\/strong>
\nOpen template:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Logchart.cpt<\/span>\u3002<\/p>\n

3.1.2 Change data set<\/strong>
\nChange the original data set to descending sort by cost price, with SQL statement of SELECT * FROM [product] where category ID= 1order by cost price desc<\/span><\/p>\n

3.1.3 View effect<\/strong>
\nView the effect in which columns are sorted descending from high to low by clicking Page Break Preview as shown above.<\/p>\n

3.2 Cell data as chart data source<\/strong><\/p>\n

3.2.1 Open template<\/strong>
\nOpen template:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Logchart.cpt<\/span>\u3002<\/p>\n

3.2.1 Change template<\/strong>
\nDrag corresponding data columns to the cell as shown below.
\n\"\"
\n3.2.3 Set sorting<\/strong>
\nRight click the cell of A2 to select Extension Attributes, set the sorting after extension to Descending in the Cell Attribute panel, and type B2 in the formula.
\n\"\"
\n3.2.4 Set dataset<\/strong>
\nSet dataset as shown below:
\n\"\"
\n3.2.5 Hide cells<\/strong>
\nHide the data in cells by selecting the first and second lines and right clicking to select Hide Lines.<\/p>\n

3.2.6 View effect<\/strong>
\nView the effect in which columns are sorted descending from high to low by clicking Page Break Preview as shown above.
\nNote: Bar charts and pie charts are set in the same way<\/span>.<\/p>\n

3.3 Template saving<\/strong>
\nChart sorting template of dataset data source is saved in:%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Logchart_3.cpt<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

1. Problem description In using a chart, it is able to display by data size. Take a column chart as an example, how to allow all columns to be sorted by data size from high to low or vice versa for better data analysis, as shown below? 2. Realization ideas The chart, a good reporting…<\/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\/4354"}],"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=4354"}],"version-history":[{"count":2,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4354\/revisions"}],"predecessor-version":[{"id":4368,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4354\/revisions\/4368"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=4354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=4354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=4354"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=4354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}