{"id":4390,"date":"2017-01-06T03:00:47","date_gmt":"2017-01-05T19:00:47","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=4390"},"modified":"2019-10-24T16:24:43","modified_gmt":"2019-10-24T08:24:43","slug":"the-introduction-of-making-a-funnel-chart","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2017\/01\/06\/the-introduction-of-making-a-funnel-chart\/","title":{"rendered":"The Introduction of Making a Funnel Chart"},"content":{"rendered":"<h3><strong>1. Overview<\/strong><\/h3>\n<p>A funnel chart, as an important <a title=\"FineReport BI and reporting tool\" href=\"\/en\/\" target=\"_blank\">reporting tool<\/a> and <a title=\"FineReport reporting and business intelligence tool\" href=\"\/en\/\" target=\"_blank\">business intelligence tool<\/a>, displays the proportion of a stage and provides analysis of conversion rate. This chart represents a single-sequence chart with a part of 100% without using any axes for clear <a title=\"FineReport data analysis\" href=\"\/en\/help\/data-analysis\" target=\"_blank\">data analysis<\/a>\u00a0and <a title=\"FineReport BI and reporting tool data visualization\" href=\"\/en\/help\/data-visualization\" target=\"_blank\">data visualization<\/a>.<\/p>\n<h3><strong>2. Example<\/strong><\/h3>\n<p><strong>2.1 Prepare data<\/strong><\/p>\n<p>Create a new workbook and add built-in dataset ds1, recording sales order type and number of orders, as shown below:<br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/010511.jpg\" alt=\"\" \/><br \/>\nNext, we will analyze the conversion rate of sales order by making a funnel chart to reflect sales opportunity status and working efficiency of salesmen.<\/p>\n<p><strong>2.2 Insert chart<\/strong><\/p>\n<p>Taking Float Chart as an example, click <span style=\"color: purple;\">Insert &gt; Float Element &gt; Insert Chart<\/span>. Select Funnel Chart and click OK.<\/p>\n<p><strong>2.3 Set chart data<\/strong><\/p>\n<p>Select Float Chart. In the right Chart Attribute Table, select <span style=\"color: purple;\">Chart Attribute Table &#8211; Data<\/span><br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/010512.png\" alt=\"\" \/><br \/>\nAs required, in the Chart Attribute Table, you can further set Chart Style. For example, set as follows:<br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/010513.png\" alt=\"\" \/><\/p>\n<p><strong>2.4 Save and preview<\/strong><br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/010514.png\" alt=\"\" \/><br \/>\nSave template and click Page-breaking Preview to see the effect as shown above.<\/p>\n<p>Click Funnel_plot.cpt to check template effect online.<\/p>\n<p>For completed templates, see: <span style=\"color: blue;\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\Funnel_plot.cpt<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Overview A funnel chart, as an important reporting t&#8230;<\/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],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4390"}],"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=4390"}],"version-history":[{"count":2,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4390\/revisions"}],"predecessor-version":[{"id":8547,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4390\/revisions\/8547"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=4390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=4390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=4390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}