Funnel Chart

The Funnel chart is typically used to represent a progressive flow of a business metric, across phases. For example, a sales pipeline progressing from Evaluation - Initial Offering - Quote/Negotiation - Closed Lost - Closed Won. Or a marketing funnel progressing from Visitors - Signups - Abandoned Cart - Purchases.

Creating a Funnel Chart

Zoho Analytics supports the following types of Funnel Chart. 

Single Series Chart

You can create a Funnel Chart for a single metric in the Y-axis, grouped by a single dimension in the X-axis. Follow the below steps to create a single series funnel chart.

  1. Open the chart editor. Drop the columns as given below.
    • X-Axis shelf - Drop the dimension column (usually a text column)
    • Y-Axis shelf - Drop the metric or aggregate column (usually a numeric or currency column)
  2. Click the Click here to Generate Graph button. A single series bar will be created.
  3. Change the chart type to Funnel.

The following animation illustrates how to create a funnel chart, showing the Sales Pipeline. 

Multi-Series Chart

You can create a funnel chart comparing multiple metrics (Multi Y-axes). Each slice (component) of the funnel represents one Y-axis metric. Follow the below steps to create a multi-series funnel chart.

  1. Open the chart editor. 
  2. Drop multiple metric (aggregate) columns in the Y-axis shelf
  3. Click the Click here to Generate Graph button. A pie chart will be created.
  4. Change the chart type to Funnel.

The following animation illustrates how to create a funnel chart, showing Leads - Converted and Won.

Customizing Funnel Chart

Zoho Analytics provides a wide range of customization options for Charts. This section explains customization options for the funnel chart. Refer here for more on chart customization options in general.

Follow the below steps to customize a Funnel Chart.

  1. Open the funnel chart.
  2. Click the Settings icon. The Settings page will open. Available customizing options are:

Show Data Label

Show Data Label section allows you to add a chart label. You can add the following as the data label. 

  • Value - Select this checkbox to add Y-Axes values as the label. 
  • Percentage - Select this checkbox to add Y-Axes percentages as the label
    • Actual Value - Choose this to add the percentage of each slice as the label.
    • Comparison with Previous Value - Choose this to add the percentage in comparison with the previous slice value as the label.
    • Comparison with first Value - Choose this to add the percentage in comparison with the first slice value as the label.

You could choose to add both Value and Percentage in the chart. You can also remove the chart label by unselecting these checkboxes. 

Show Conversion Rate

Select this to display the conversion rate of the funnel in percentage, by comparing the value of the last slice with the first slice in the funnel.

Funnel Design

Zoho Analytics supports the following funnel design. 

  • Weighted Height  - The height of each slice will be proportional to the data value. 
  • Uniform Height - Each slice will be in uniform height.
  • Weighted Width - The width of each slice will be proportional to the data value.

Legend Value

You can choose to display the legend items with or without the corresponding values. You can also customize the format to display data using the Format link. 

Possible combinations for creating Funnel Charts

The following combinations of column types are possible when creating Funnel charts.

 X-axisY-axisColorTextTooltip
Case 1DimensionAggregate--Aggregate/
Measure/
Optional
Aggregate/
Measure/
Optional
Case 2OptionalMultiple Aggregate--Aggregate/
Measure/
Optional
Aggregate/
Measure/
Optional
  • Dimension: Usually, it is a column with Text values. If it is a numeric column, Actual Value function is applied over it. The Actual Value will further be divided into Actual Measure, Actual Dimension, and Actual Range, from which you can choose the appropriate function. 
  • Aggregate: A numeric or currency column with an aggregate function (sum, average, count, etc) applied over it. This also includes the aggregate formula columns.