Funnel charts work well for showing pipeline performance, product conversion metrics, onboarding flows, or any other process where things move from one discrete stage to another.
To use a funnel chart, you should have discrete stages of a process and numeric counts of entities in each stage.
The funnel will show the count at each stage and the percentage that number represents of the starting count, making it easy to visualize the proportion moving from one stage to the next.
General settings
With the Lightdash funnel chart, you can use either a row or a column to describe the stages in your funnel.
Use the Data orientation switch to specify which orientation you would like to use.
When rows is selected, each row of your data represent one step. The first column in the data will be treated as the labels for the steps, and you can choose which numeric column to treat as the value of the step.
When columns is selected, you should have a numeric column for each step you want to display. Only the first row of data will be represented and the column names will be used as the step labels. Non-numeric columns will be ignored.
Referencing the active granularity in labels
Step labels support a ${table_field.granularity} placeholder that resolves to the active date granularity (for example day, week, month) ā including the granularity selected via date zoom. Click the insert date granularity icon inside the editable step label field to insert the placeholder without typing it manually. See Referencing the granularity in chart labels for the full syntax and supported labels.
Step labels are per-step overrides keyed to a specific category value. Date zoom re-buckets the underlying dates (for example, a monthly 2024-07 step becomes a weekly 2024-07-15 step), so an override set at one granularity stops matching after a viewer zooms to another and the custom label silently falls back to the raw value.
