Funnel Chart
Funnel charts are most often used in marketing and business where there’s a need to track a value that decreases as it passes through certain stages. An example of such a value is the number of leads that travel through the sales cycle or the number of job candidates as they go through the interview and hiring process.
Creating a Funnel Chart
To create a Funnel Chart, we need one column as a Category and one as a Value. We drag and drop a data field from the Data Panel onto either the corresponding shelf or the canvas.
In the case below, we want to get a visual representation of the hiring process within the company. We drag and drop Stage onto the Category shelf, and CandidateID onto Values and set its aggregation to Count. We adjusted the Mode to Width. This setting may provide a better view, depending on the size of each segment.
Styling The Funnel Chart
In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.
General
The General section is available for all chart types, and the options vary depending on the chart selected. For more information on the options, see General Chart Settings.
Styles
The Styles section enables you to control various visual elements of the charts, such as colors, labels, and more. It is available for most chart types, and the options vary depending on the chart selected. For a glossary of all styles, see Styles. Style options specific to this chart are listed below.
- Color Type
- Single - all bars are the same color.
- Color - change the color of the bars.
- By category - each bar is colored based on its category.
- Theme - set one of the predetermined themes for a more unified look of your charts.
- Match colors across charts - unify the colors of each categorical value throughout the page and application.When this option is selected and the same categorical column is used, the system will unify the colors of each categorical value throughout the page and application. For example, if there’s a “Country” column chosen with the Values Argentina, Colombia, US, and then we have the same “Country” column in the Funnel chart, then Argentina, Colombia, US will have the same color in both charts.
- Single - all bars are the same color.
- Mode - can change the visualization of the Funnel Chart by switching between Height and Width in Mode.
- The Width mode shows the highest, more prominent aggregate at the top and then narrows down to the lowest one(s) with aggregate segments of equal value having uniform width.
The Height mode shows the highest value (or the lowest one, depending on the Sorting settings) at the top and then gradually narrows down with each stage being smaller in size than the previous one, regardless of its value.
Category Labels - show or hide Category name.
- Category Name - The custom name you want to give to your Category axis (Y-axis).
- Segment Names - By unchecking the box next to Segments names, you can hide the category values (from the Category field) as they appear in the dataset. If the label for the category overlaps with the previous one it’s hidden from the funnel, but can be seen in the tooltip when you mouse-over the segment.
- Names Rotation - If you decide to keep Segments names, you can choose them to appear in Horizontal, Diagonal or Vertical position.
Data Labels - enable or disable showing Data Labels, which represent data values from the dataset column assigned to the Value shelf.
Values - display the data fields as actual Values or as Percentages.
Percentage - the values shown in the segments do not represent the percentage of the total, but instead, they show the percentage of the max value, which is calculated by dividing the current value by the maximum value.
Format
You can apply Conditional Formatting to your Funnel Chart.
Sorting
You can sort Values directly from the column pill or in case you’d like to sort by a different column, go to the Sorting section of the Configuration Panel, pick your desired column from the dropdown, and select the sorting direction.
The sorting options include a drop-down list of all the values in the dataset from which you can choose your Sort by preference that can be arranged in either ascending or descending order.
For more information, see Sorting.
Filters
You can also add Filters to your data by expanding the Filters section in the configuration panel or by clicking on the Filters button in the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from End Users. These types of filters can’t be edited or interacted with in the view mode. For more information, see Filters.
For more on Funnel Charts and other Percent of Total charts, we recommend watching this video.