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
Labels support a ${table_field.granularity} placeholder that resolves to the active date granularity — for example day, week, or month — including the granularity a viewer selects with date zoom. Click the insert date granularity icon inside the editable label field to add it without typing. See Referencing the granularity in chart labels for the full syntax and the complete list of supported labels.
These labels are per-category overrides keyed to a specific value. Date zoom re-buckets the underlying dates — a monthly 2024-07 category becomes a weekly 2024-07-15 category — so an override set at one granularity stops matching after a viewer zooms to another, and the label silently falls back to the raw value.
