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.
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.INCdoes. - 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.
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.
