Skip to main content

Documentation Index

Fetch the complete documentation index at: https://lightdash-feature-flag-env-variables.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

This feature is in Beta. Weโ€™d love your feedback as we continue to improve it.
Sankey diagrams visualize flows between categories โ€” how values move from a source to a target, weighted by a metric. Theyโ€™re ideal for understanding movement, distribution, or conversion across stages. Sankey charts are useful when:
  • You want to show how values flow between categories (e.g., marketing channels โ†’ conversions)
  • Youโ€™re visualizing multi-step processes or funnels
  • You need to understand distribution across interconnected stages
  • You have cyclical flows that loop back (e.g., retargeting โ†’ conversion โ†’ retargeting)

Data requirements

Sankey charts require three columns in your data:
Column typeDescriptionExample
Source dimensionWhere the flow originateschannel, referrer, stage_from
Target dimensionWhere the flow goesconversion_type, destination, stage_to
Weight metricThe size of the flowcount, revenue, users
Each row in your data represents a flow from one node to another, with the weight determining the thickness of the connection.

Creating a Sankey chart

  1. Run a query with your source dimension, target dimension, and weight metric
  2. Select Sankey from the chart type picker
  3. In the configuration panel, assign:
    • Source โ€” the dimension representing flow origins
    • Target โ€” the dimension representing flow destinations
    • Value โ€” the metric determining flow size

Features

Multi-step flows

Sankey charts automatically handle nodes that appear as both sources and targets, creating multi-level visualizations. For example, if โ€œEmailโ€ appears as a target from โ€œAd Clickโ€ and as a source to โ€œPurchaseโ€, the chart will show the full flow path.

Cyclical flows

Unlike traditional Sankey implementations, Lightdash supports cyclical data where flows can loop back. For example, in a retargeting funnel:
  • Awareness โ†’ Consideration
  • Consideration โ†’ Conversion
  • Conversion โ†’ Retargeting
  • Retargeting โ†’ Conversion (loop)
The chart handles these cycles by creating step-suffixed node instances (e.g., โ€œConversion - Step 2โ€).

Display options

  • Orientation โ€” Display flows horizontally (left to right) or vertically (top to bottom)
  • Node alignment โ€” Align nodes to the left, right, or justify across the chart