Funnel charts are best used to understand events in a process, like a signup flow, or counts of customers who make subsequent orders. You can choose to use a funnel visualization by clicking the ellipsis (…) in the Visualization bar and choosing Funnel.
This page describes the options for editing funnel charts in the visualization menu. This menu can be accessed by clicking the gear in the upper right corner of the visualization tab.
A funnel chart is composed from a single set of numbers and a single set of labels. In Looker, this information can be oriented vertically (one column with labels, and one column with numbers) or horizontally (a single row with numbers, and the column headers are the labels). The chart can work with both pivoted and non-pivoted data.
If you include multiple numeric columns, the funnel chart will use the first column. If you include multiple numeric rows, the funnel chart will use the first row. If you include both multiple numeric columns and rows, the funnel chart will check the first row and the first column, then display whichever one produces the most data points. However, you can use the Orientation setting to change the way the funnel reads the data table and flip the axes to go the other way.
Please note that some of the options listed in the menu may be grayed out or hidden in situations where they would conflict with other settings you have chosen.
Axes Menu Options
Label Left Axis
Turn on Label Left Axis to apply a label to the left axis. Looker will display a box where you can enter the label text.
Label Right Axis
Turn on Label Right Axis to apply a label to the right axis. Looker will display a box where you can enter the label text.
Bars Menu Options
The Bar Colors section lets you define the color palette for the chart.
Selecting a Color Collection and Palette
Choose a color collection from the Collection drop-down menu. A collection allows you to create themed visualizations and dashboards that look good together. You can see all the palettes in each of Looker's built-in color collections on the Color Collections documentation page. Your Looker admin may also create a custom color collection for your organization.
Once you select a color collection, the Palette section will update with a palette from that collection. If you'd like to change to a different palette in the color collection, click the color palette, which opens the palette picker. From there, you can view and select from all the palettes in the collection.
Choosing the Type of Palettes
If you use a sequential or diverging palette, each bar is colored on a scale along the palette. If you change to a categorical palette (a palette composed of multiple individual colors), colors are assigned to each bar in order. The first bar is assigned the first color, and so on. If there are more bars than colors listed, the colors repeat from the beginning of the palette.
Creating a Custom Color Palette
To create a custom color palette, first select the Custom tab on the palette picker. You can edit your palette in several ways:
- Click on one of the colors present to edit it.
- Click the + or - buttons below the color palette to add a color to the end of the palette or remove a selected color. When you add a color to the end of a sequential or diverging palette, Looker automatically creates a scale between that color and the previous one.
- Click EDIT ALL at the bottom right of the menu to use a comma-separated list of color values.
To change a selected color, or edit all colors at once, you can input hex strings, such as
#2ca6cd, or CSS color names, such as
mediumblue, into the color value box at the bottom of the menu.
You can also click the color wheel to the right of the color value box to bring up a color picker, which you can use to select a color. The corresponding hex value for that color appears in the color value box:
If you click EDIT ALL, you'll see that the color value box is populated with all the hex codes of the color palette you've chosen or customized. Copying and pasting this list is the best way to copy custom color palettes from one chart to another.
Select Reverse colors to reverse the palette. For a sequential or diverging palette, each bar is colored on a scale along the palette in reverse order, starting with the color at the right end of the palette and moving to the left. For a categorical palette, this would apply the colors in the palette to each bar in reverse order, starting with the last color in the palette.
Smoothed Bars toggles whether to connect the outer edge of each bar in the funnel chart with the bars above and below it.
Orientation lets you specify whether the data for the funnel chart is drawn from the table rows or columns. You can also choose Automatic, which causes the funnel chart to choose data based on where there are the most data points.
Label Scale lets you specify the size of labels that are positioned both on top of the chart bars and on the sides of the chart. Labels have a minimum size and a maximum size which varies depending on the size of the chart. Enter a 0 to specify that the labels will be the minimum size. Enter a 1 to specify that the labels will be the maximum size. Enter a number between 0 and 1 to indicate a percentage, and the label size will be set to that percentage between the minimum and maximum size.
Labels Menu Options
Label Position lets you specify where your data labels will appear on the chart. You can choose:
- Left: data labels are on the left side of the chart
- Inline: data labels are in the center of the chart, inside the chart bars
- Right: data labels are on the right side of the chart
- Hidden: data labels are not shown
Each bar in the chart is assigned a percentage value. Percent Type determines whether each bar is assigned a percentage by comparing the bar's value to the largest value in the chart, or by comparing the bar's value to the previous bar in the chart.
Percent Position lets you specify where bar percentages will appear on the chart. You can choose:
- Left: percentages are on the left side of the chart
- Inline: percentages labels are in the center of the chart, inside the chart bars
- Right: percentages labels are on the right side of the chart
- Hidden: percentages labels are not shown
Value Position lets you specify where your data values will appear on the chart. You can choose:
- Left: data values are on the left side of the chart
- Inline: data values are in the center of the chart, inside the chart bars
- Right: data values are on the right side of the chart
- Hidden: data values are not shown
Color Label toggles whether to set a custom color for labels and percentages in the chart. If you toggle on Color Label, a color box appears. Click on the box to display the color picker and choose a custom color for the label and percentages. Inline labels will appear in the color chosen, and labels on either side of the chart will appear about 40% darker than the chosen color.