Skip to main content
This feature is in Early Access. 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