Funnel Chart

  • Last update:January 19, 2025
  • Overview

    Version

    Report Server Version

    Functional Change

    11.0.2

    Added: Added Ascend and Descend under Style > Series, by which you can create a pyramid chart.

    Application Scenario

    The funnel chart resembles a funnel, always starting with a quantity of 100% and ending with a smaller quantity. The funnel chart has a logical order from top to bottom, and displays the differences between each part by the area of each part.

    The funnel chart is suitable for single-process and one-way analysis of standardized business processes with long cycles and multiple steps. By comparing the business data of each part through the funnel, you can intuitively identify and explain the problematic parts to make decisions.

    Two complementary indicators conversion rate and churn rate are most commonly used in the funnel analysis, such as the recruitment conversion rate analysis, as shown in the following figure.

     image 46.png

    Chart Feature

    Advantage: The funnel chart intuitively displays the proportional relationship of each stage, so the chart is suitable for data tracking of process optimization.

    Disadvantage: The funnel chart is not suitable for displaying comparisons between categories with no logical order, so the chart is not suitable for representing proportions.

    Example

    Data Preparation

    1. Choose File > New General Report in the upper left of the designer, and select Refresh Technology as the template theme.

    2. Create a Built-in Dataset Number of People Recruited at Each Stage. The following figure shows the data structure.

    image 47.png

    Chart Insertion

    Merge required cells, click the Insert Chart icon on the upper toolbar, select Funnel Chart, and click OK, as shown in the following figure. /

    image 48.png

    Funnel Chart Design

    Select the chart, click the Cell Element icon on the right property panel, and set the attributes (Type, Data, Style, and Special Effect) for the chart.

    Data Binding

    Click Data and bind the required data to the chart, as shown in the following figure.

    image 49.png

    Style Setting

    1. Title Setting

    Choose Style > Title and enter Recruitment Conversion Rate, as shown in the following figure.

    image 50.png

    2. Label Setting

    Select Use Label to display Series and Conversion.

    Conversion refers to the percentage produced by dividing the value of the current series by the value of the previous series. Format is defaulted to #.##%, and you can modify the number of decimal places displayed.

    image 51.png

    iconNote:
    The label displays the series name, and you can deselect Show Legend in Style Legend.

    3. Series Setting

    Select Discontinuous as Continuity, and Descend as Sort, as shown in the following figure.

    • Continuity: When Continuous is selected, the overall shape of the chart is triangular. When Discontinuous is selected, the overall shape of the chart is irregular.

    • Sort: When Ascend is selected, the chart is inverted, with the smallest value at the top, which can be used to create a pyramid chart. When Descend is selected, the smallest value is at the bottom. When None is selected, the data is sorted according to the order in the dataset.

    image 52.png

    Effect Display

    PC

    Save the template and click Pagination Preview. The effect is same as that shown in section "Application Scenario".

    Mobile Terminal

    The template can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

    9228b023b16effa03c7a909a5bd9d75.jpg

    Deformed Funnel Chart

    You can modify Continuity and Sort under Series > Style to set multiple style effects.

    The following figure shows the general effect.

     


    Template Download

    For details, you can click to download the template Funnel Chart.cpt.

    Attachment List


    Theme: Chart
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy