Skip to navigation

Build a funnel chart

View as Markdown

Funnel charts are typically used to measure values across sequential stages in a linear process. Create funnel charts to evaluate inputs across each stage and discover potential issues and bottlenecks in a workflow.

This document details basic funnel chart requirements and introduces key properties and format options to help you enhance your workbook visualizations.

Funnel chart with five horizontal bars that narrow from the widest stage at the top to the narrowest at the bottom.

Example use cases:

  • Product marketing analytics: Monitor an email campaign pipeline to understand where most prospects are being lost, then assess opportunities for greater conversion.
  • Sales analytics: Track the number of prospects in each stage of the sales cycle to identify where most prospects are currently held, then assess investments in specific sales motions.
  • HR analytics: Analyze recruiting process stages by demographics (like age, gender, and application submitted) to measure pipeline dropoff rate for specific candidate groups, then determine if dropoff exceeds expectations and indicates a need for process refinement.

User requirements

The ability to create funnel charts and other charts requires the following:

  • You must be assigned an account type with the Edit Workbook and/or Explore Workbook permission enabled.
  • You must be the workbook owner or be granted Can explore or Can edit workbook permission.

If you’re granted Can explore access to the workbook, you can create and modify chart properties and formatting in Explore mode, but you cannot publish your changes.

Workbook prerequisite

Before you can build a funnel chart, you must add a new chart element and select a data source.

At the core of every chart is an underlying data table (derived from the data source) that supplies the information visualized by the chart. As you build a funnel chart, Sigma automatically groups, aggregates, and calculates the underlying data to create source columns for various chart properties. You can view the underlying data table while configuring the chart to see how the data is applied.

Basic funnel chart requirements

To display a funnel chart, configure the following properties in the Element properties panel:

  • Chart - chart type displayed in the workbook
  • Stage - source column that defines the stages
  • Value - source column that defines the variable

In a funnel chart, stages reference nominal categories (like campaign pipeline, sales pipeline, recruitment stages) presented as a horizontal bars. A variable measures a value (like number of leads, prospects, candidates) for each stage and determines the width of each bar.

The first stage, shown at the top of the chart, typically represents the initial input of the process and corresponds with the largest stage value (and widest bar). Because value dropoff occurs as data flows through the process, each stage measures a subset of the previous stage value. As a result, the chart progressively narrows and creates a funnel shape.

Select the chart type

After you add a new chart to a workbook, select the chart type:

  • In the Chart property, click the dropdown field and select Funnel from the list.

The chart type dropdown open in the element properties panel, with Funnel under the cursor in the list.

You can also use this dropdown field to convert an existing chart to a different type. Sigma retains all property and format configurations shared by the initial and new type. Unshared properties and formatting are not saved or restored if you further convert the chart.

Define the stages

Select a source column to define the stages.

When your data source includes a single column with stage names as values, follow the steps below and add this column to the Stage property. Alternatively, if the data source breaks down each stage as a distinct column of data, skip this step and aggregate the individual stage columns in the Value property (see Define the Variable).

  1. In the Stage property, click Add column and select an option from the menu:

    • To generate stage names based on distinct values in an existing column, search or scroll the Select column list and select the preferred column name.

    • To generate stage names based on a custom formula, select New column and enter a formula in the toolbar.

    You can also select or replace an existing column by dragging and dropping a column name from the Columns list to the Stage property.

    The Stage property menu open on a new funnel chart, with Status under the cursor in the Select column list.

Define the variable

Configure a source column to define the variable. Sigma automatically aggregates column values associated with the same stage.

  1. In the Value property, click Add calculation and select an option from the menu:

    • To aggregate values of an existing column, search or scroll the Aggregate column list and select the preferred column name.
    • To calculate values based on a custom formula, select New column and enter a formula in the toolbar.
    • To count the number of rows associated with each stage, select Row count.

    The Value property menu open on a funnel chart with Status as the stage, listing Row count and the Front End, Back End, and Full Stack columns to aggregate.

    You can also select an existing column by dragging and dropping a column name from the Columns list to the Value property.

  2. (Optional) Control how the source column data is calculated and displayed in the chart:

    1. Hover over the source column name, then click the caret () to open the column menu.
    2. Hover over any of the following items and select the preferred option:
      • Set aggregate - Calculate values based on the selected aggregation method.

      • Transform - Convert the column to the selected data value type.

      • Format - Display data labels in the selected format.

    To plot the source column data without aggregating values, clear the Aggregate values checkbox in the Value property. If this results in an incomplete chart that exceeds the 25,000 data point limit, reaggregate the values or apply data filters to reduce the number of data points.

    The column menu for Sum of Front End in the Value property, with the Format submenu open and Whole number under the cursor.

    You can also use the toolbar to change the aggregation method (using the formula) and data label format.

  3. (Optional) Repeat the previous steps to configure multiple stage value source columns. Sigma plots the columns as stacked series on the chart.

Funnel chart titled Sum of Front End and Sum of Back End and Sum of Full Stack by Status, with 3 Value columns plotted as stacked series across 6 stages from Applied to Hired.

  1. (Optional) Sigma auto-generates source column names and chart titles to reflect the visualized data, but you can customize these fields as needed:

    • To rename a source column, double-click the column name in the Stage or Value property, then enter a new name. Changes are reflected in the default chart title.

    • To edit the chart title, double-click the title in the chart, then enter a new title.

    Sigma auto-generates the default chart title only. Once the title is customized, it no longer reflects changes to source columns and their names.

    Funnel chart with the title field active and set to Recruitment - Engineering, and the source columns renamed Stage, Front-end, Back-end, and Full-stack.

Advanced funnel chart properties and formatting

Sigma features various properties and format options that give you the flexibility to build detailed funnel charts.

The following sections introduce configurations that can enhance your charts and help you deliver specific insights with meaningful and actionable information.

Configure mark colors

Configure chart mark colors in the Element properties > Marks > Color tab to differentiate data.

The Marks section with the Color tab selected, showing the By category option and a categorical color palette.

Mark color
By category

If only one source column is configured in the Value property, the chart defaults to categorical colors that represent stages.

If multiple source columns are configured in the Value property, the chart defaults to stacked series with categorical colors that represent each of those columns.

To change the default categorical color variable, select a source column, then select or customize a color palette.

Funnel chart with five stages, each filled with a different color.Funnel chart with five stages, each split into four stacked colored segments, one for each Value column.
By scaleSelect a source column to define a scaled color variable, then select a color range to apply to the marks.Funnel chart with five stages shaded on a color scale from dark blue at the top stage to pale yellow at the bottom stage.

Customize data labels

Customize data labels representing conversion rates, stage values, and stage names in the Element format > Data labels section.

The Data labels section with conversion rate, value, and stage name labels shown, each at size 14, and Percentage style set to % of total.

In addition to showing or hiding the different types of data labels, you can customize the font size and color of each.

You can also select the position of each data label type relative to the chart marks:

LeftInlineRight
Funnel chart with the stage names Leads, Sales Calls, Follow Up, Conversion, and Sales displayed to the left of the bars.Funnel chart with the stage names Leads, Sales Calls, Follow Up, Conversion, and Sales displayed inside the bars.Funnel chart with the stage names Leads, Sales Calls, Follow Up, Conversion, and Sales displayed to the right of the bars.

The funnel chart’s Color property may determine the availability of specific data labels and positions. For example, stage names can only be displayed inline when the chart features categorical colors that represent stages (see the By category details in Configure mark colors).

When you show conversion rates, you can choose a Percentage style option to determine how conversion rates are calculated:

Percentage style
% of total

Calculates the value of each stage against the value of the first stage (total value at the top of the funnel).

Current stage / first stage = conversion rate

% of prior

Calculates the value of each stage against the value of the preceding stage.

Current stage / preceding stage = conversion rate

All funnel chart format options