The Funnel Chart component for Retool Apps

A content area to display funnel charts.

Version: Cloud and 3.188 Edge

The Funnel Chart component renders data in a funnel shape, with sections of decreasing size. Funnel Chart is useful for visualizing data in different stages of a process.

Demo

For more information about using the Funnel Chart component, refer to the charts guide.

Properties

All properties for this object with supported data types or values. You can write JavaScript almost anywhere in Retool to manipulate or read property values.

chartType

The type of chart to display.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector > Content > Series > Chart type
Allowed Values	Value UI Option Description bar Bar Bar Chart or Stacked Bar Chart. bubble Bubble Bubble Chart. funnel Funnel Funnel Chart. heatmap Heatmap Heat Map. line Line Line Chart or Sparkline. mixed Mixed Mixed Chart. pie Pie Pie Chart. plotlyJson Plotly JSON Plotly JSON Chart. sankey Sankey Sankey Chart. scatter Scatter Scatter Chart. sunburst Sunburst Sunburst Chart. treemap Treemap Treemap. waterfall Waterfall Waterfall Chart.
Default	funnel

Examples

"bar"

---

clearOnEmptyData

Whether to clear the chart when the data is empty.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Content > Clear when data is empty
Default	false

Examples

true

---

colorArray

A list of colors to use when colorInputMode is colorArray.

Type	array
Format	Color
Array values	string
Mutability	Control Usage Retool UI Inspector

Examples

["#ff0000", "#00ff00", "#0000ff"]

---

colorArrayDropDown

A list of colors to use when colorInputMode is colorArrayDropDown.

Type	array
Format	Color
Array values	string
Mutability	Control Usage Retool UI Inspector > Appearance > Color selection

Examples

["#ff0000", "#00ff00", "#0000ff"]

---

colorInputMode

The mode for the color input.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector > Appearance > Color selection
Allowed Values	Value UI Option Description colorArray Array Color array. gradientColorArray Palette Gradient color array. colorArrayDropDown Manual Color array dropdown.
Default	colorArray

Examples

"colorArray"

---

gradientColorArray

A list of colors to use when colorInputMode is gradientColorArray.

Type	array
Format	Color
Array values	string
Mutability	Control Usage Retool UI Inspector > Appearance > Color selection

---

hidden

Whether this object is hidden from view.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Appearance > Hidden Method setHidden()
Default	false

Examples

true

---

id

The unique identifier (name).

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector
Default	funnelChart1

Examples

query1

button1

---

isHiddenOnDesktop

Whether to show or hide this object in the desktop layout.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Appearance > Advanced > Show on desktop
Default	false

Examples

true

---

isHiddenOnMobile

Whether to show or hide this object in the mobile layout.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Appearance > Advanced > Show on mobile
Default	true

Examples

true

---

legendPosition

The position of the legend.

Type	string
Mutability	Control Usage Retool UI Inspector > Content > Add-ons > Legend position
Allowed Values	Value UI Option Description top Align top Top. right Align right Right. bottom Align bottom Bottom. left Align left Left. none No legend None.

---

maintainSpaceWhenHidden

Whether to take up space on the canvas if hidden is true.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Appearance > Advanced > Maintain space when hidden
Default	false

Examples

true

---

margin

The amount of margin to render outside.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector > Spacing > Margin
Allowed Values	Value UI Option Description 4px 8px Normal Normal margin. 0 None No margin.
Default	4px 8px

Examples

4px 8px

---

paperBgColor

The paper background color.

Type	string
Mutability	Read-only

---

plotBgColor

The plot background color.

Type	string
Mutability	Read-only

---

selectedPoints

A list of selected points.

Type	array
Array values	object
Mutability	Read-only

---

series

The chart series data.

Type	object
Mutability	Control Usage Retool UI Inspector

Object Properties

yAxis

The y-axis configuration.

Type	object
Mutability	Control Usage Retool UI Inspector

Object Properties

lineWidth

The width of the line.

Type	number
Mutability	Read-only

---

rangeMax

The maximum value of the axis.

Type	number
Mutability	Control Usage Retool UI Inspector

---

rangeMin

The minimum value of the axis.

Type	number
Mutability	Control Usage Retool UI Inspector

---

rangeMode

The range mode of the axis.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description auto Auto. manual Manual.

---

scale

The scale of the axis.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description linear Linear. log Logarithmic. time

---

showGridLines

Whether to show grid lines on the axis.

Type	boolean
Mutability	Control Usage Retool UI Inspector

---

showLine

Whether to show the axis line.

Type	boolean
Mutability	Control Usage Retool UI Inspector

---

showTickLabels

Whether to show tick labels on the x-axis.

Type	boolean
Mutability	Control Usage Retool UI Inspector

---

showZeroLine

Whether to show the zero line on the x-axis.

Type	boolean
Mutability	Control Usage Retool UI Inspector

---

sort

The sorting of the axis.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description none None. ascending Ascending. descending Descending.

---

tickFormat

The format of the axis tick labels.

Type	string
Mutability	Control Usage Retool UI Inspector

---

title

The axis title.

Type	string
Mutability	Control Usage Retool UI Inspector

---

---

aggregationType

The type of aggregation to use.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description none None. sum Sum. average Average. count Count. countDistinct Count of distinct values. max Maximum. min Minimum. median Median. mode Mode. standardDeviation Standard deviation. first First Value. last Last Value.
Default	none

Examples

"sum"

---

dataLabelPosition

The position of the label relative to the input field or value.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector > Content > Add-ons > Label > Position
Allowed Values	Value UI Option Description top Top Above the input field or value. left Left Left of the input field or value.
Default	left

Examples

top

---

dataLabelTemplate

The template for the data label.

Type	string
Mutability	Control Usage Retool UI Inspector

---

datasource

The source data when using UI Form.

Type	array
Array values	object
Mutability	Control Usage Retool UI Inspector

---

groupBy

The column to group by.

Type	array
Mutability	Control Usage Retool UI Inspector

---

groupByStyles

The styles of grouped data.

Type	string
Mutability	Read-only

---

hoverTemplate

The tooltip template for displaying information when you hover over a point.

Type	string
Format	Plain Text
Mutability	Control Usage Retool UI Inspector > Content > Add-ons > Tooltip
Default	%{value}<br>%{percent}<extra></extra>

Examples

%{value}<br>%{percent}<extra></extra>

---

lineColor

The color of the line.

Type	string
Format	Color
Mutability	Control Usage Retool UI Inspector > Content > Series > Appearance > Line color
Default	#000000

Examples

#000000

#FFFFFF

---

lineDash

The style of the line.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description solid Solid. dash Dashed. dot Dotted.

---

lineShape

The shape of the line.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description linear Linear. spline Spline. hv Horizontal-Vertical. vh Vertical-Horizontal. hvh Horizontal-Vertical-Horizontal. vhv Vertical-Horizontal-Vertical.

---

lineWidth

The width of the line.

Type	number
Mutability	Read-only

---

markerBorderColor

The border color of the marker.

Type	string
Mutability	Control Usage Retool UI Inspector

---

markerBorderWidth

The border width of the marker.

Type	number
Mutability	Control Usage Retool UI Inspector

---

markerColor

The color of the marker.

Type	string
Mutability	Control Usage Retool UI Inspector

---

markerSymbol

The type of marker.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description circle Circle. square Square. diamond Diamond.

---

name

The name.

Type	string
Mutability	Read-only

---

showMarkers

Whether to show markers for data points.

Type	boolean
Mutability	Control Usage Retool UI Inspector

---

type

The type of series to display.

Type	string
Mutability	Control Usage Retool UI Inspector
Allowed Values	Value Description line Line. bar Bar. scatter Scatter. waterfall Waterfall.

---

xData

The x-axis data.

Type	array
Array values	object
Mutability	Read-only

---

yData

The y-axis data.

Type	array
Mutability	Read-only

---

---

showInEditor

Whether the component remains visible in the editor if hidden is true.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector > Appearance > Advanced > Always show in edit mode
Default	false

Examples

true

---

toolbar

The toolbar configuration.

Type	object
Mutability	Control Usage Retool UI Inspector > Content > Add-ons > Toolbar

Object Properties

showAutoscale

Whether to show the Autoscale button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showBoxSelect

Whether to show the Box select button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showLassoSelect

Whether to show the Lasso select button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showPan

Whether to show the Pan button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showResetViews

Whether to show the Reset view button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showToImage

Whether to show the Download as PNG button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showZoomIn

Whether to show the Zoom in button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showZoomOut

Whether to show the Zoom out button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

showZoomSelect

Whether to show the Zoom select button.

Type	boolean
Format	True/False
Mutability	Control Usage Retool UI Inspector

Examples

true

---

---

Methods

JavaScript API methods for this object. You can write JavaScript almost anywhere in Retool and use methods to manipulate data and property values.

funnelChart.scrollIntoView()

Scrolls the canvas or parent container so that the selected component appears in the visible area.

Definition

funnelChart.scrollIntoView(options)

Parameters

options

The scroll options.

Type

object

Object Properties

behavior

The scroll behavior.

Type	string
Allowed Values	Value Description auto Scroll immediately to the specified position. smooth Scroll gradually to the specified position.

---

block

The scroll position relative to the component.

Type	string
Allowed Values	Value Description nearest Scrolls only the minimum amount required for the component to appear in the visible area. Scrolling does not occur if the component is already in view. start Scrolls to position the component at the top of the visible area. center Scrolls to position the component in the middle of the visible area. end Scrolls to position the component at the bottom of the visible area.

---

---

Examples

Scroll the minimum amount to immediately bring funnelChart into view.

funnelChart.scrollIntoView({behavior: 'auto', block: 'nearest'});

---

funnelChart.setHidden()

Set the hidden value to toggle whether the component is visible. Defaults to true without a parameter.

Definition

funnelChart.setHidden(hidden)

Parameters

hidden

Whether this object is hidden from view.

Type	boolean
Format	True/False
Default	false

Examples

true

---

Examples

Hide funnelChart.

funnelChart.setHidden(true);

Unhide funnelChart.

funnelChart.setHidden(false);

---

Events

Events triggered by user interactions. You can configure event handlers in the IDE to trigger queries or other actions in response to events.

Event	Description
Clear	A value is cleared.
Hover	An item is hovered over.
Legend Click	A legend item is clicked or pressed.
Legend Double Click	A legend item is double-clicked or pressed.
Select	A value is selected.
Unhover	An item is no longer hovered over.