Sankey, Box Plot, Radar and Gantt

Four chart types for flows, spreads, profiles and schedules. Pick one from the chart icons like any other type. All built-in types are listed in Chart Types.

ℹ️ What's different about these four Each one reads every attribute in "For every" at once, instead of one level at a time. So they don't drill down. Hover a node, box, shape or bar for its details.

Sankey

Shows how a quantity flows from one stage to the next, such as orders from country to status, or leads from source to stage to outcome.

  • For every: two or more attributes, one per stage, left to right. With fewer than two, the chart asks for another.
  • Show me: one measure, which sizes the flows. Only the first visible measure is used. Rows where it's empty, zero or negative are left out.
  • The same value at two stages (for example "Online" as a channel and as a segment) appears as two separate nodes.
  • Empty values show as (Blank).
  • Options (on the measure): Align stages (spread across, left or right) and Flow colour (blend source to target, or the source's colour).

Hover a node for its total, or a flow for source → target and its value.

Box Plot

Shows the spread of a measure: its middle, its range, and the values that stand out.

  • For every: the first attribute gives one box per value. Any further attributes decide what one observation is. For example, Status, Customer draws one box per status over customer totals.
  • Show me: one or more measures. Each measure gets its own boxes side by side.
  • Segment / Pivot data by: optional. Gives side-by-side boxes, one per value.
  • The box runs from the first quartile to the third, with a line at the median. Quartiles are worked out the way Excel's QUARTILE.INC does.
  • Whiskers (on the measure):
    • 1.5 × IQR, outliers as dots (default): whiskers reach the furthest value within 1.5 × the box's height, and anything beyond is drawn as a dot.
    • Minimum to maximum: whiskers reach the lowest and highest values, and no dots are drawn.
  • Axis Id and Axis Type put a measure on a secondary axis, as on column charts.

Hover a box for its whiskers, quartiles, median, mean and number of observations.

Radar

Compares several values at once as a shape, such as one score per skill, or sales per region for two years.

  • For every: the attribute whose values become the spokes. Several attributes are joined as A / B.
  • Show me: one shape per measure.
  • Segment / Pivot data by: optional. Gives one shape per value instead.
  • Options (on the measure):
    • Scale: One scale for all spokes (default) compares spokes against each other. Scale each spoke gives each spoke its own maximum, for spokes that are different kinds of number.
    • Grid shape: polygon or circle.
    • Fill shapes: on by default.
💡 Tip Measures of very different sizes on one radar (a count and a revenue) leave the smaller one as a dot near the centre. Put them on separate radars.

Gantt

Shows tasks as bars on a timeline, from a start date to an end date.

  • For every: the task. Several attributes are joined as Project / Task. Tasks are listed in the order the data returns them.
  • Show me: two date measures, a start and an end. Set Gantt part on each to Start date or End date. Left on Auto, the first measure is the start and the second the end.
  • A task on several rows runs from its earliest start to its latest end. A start after its end is swapped. Rows missing either date are left out.
  • Segment / Pivot data by: optional. Colours the bars by value, such as phase or owner, with a legend entry per value.
  • Show today line (on the measure, on by default): a dashed line at today's date.
  • With more than 20 tasks, a scroll bar appears on the right.

Hover a bar for its start, end and duration in days. Dates are shown in the viewer's own date format.

💡 Next See Customizing Visuals for titles, number formats and prefixes. The tooltips use each measure's axis label format.