Skip to content

Charts

The Waterfall module of Compare shows one analysis in four views that stay in sync: the waterfall, the tree, the table and the comment.

  • The first and last bars are your KPI at Start and at End.
  • Each bar in between is a step of the market equation, sized by its impact on the KPI. Green bars raise the KPI, red bars lower it.
  • The label of a bar shows its impact on the KPI, or the gap in points of the total step (see Displayed value in the visual settings).

Click a step to open it: the waterfall shows the segments of the most interesting dimension that explain it. By default, the first driver opens on its own when the chart loads.

Only the most impacting segments are shown (6 by default); the others are grouped into a Remaining bar. Click it to show more segments; right-click, then Regroup remaining, to group them back.

Right-click a bar or a label to:

Action Effect
Split by… Change the dimension used to explore this branch.
Drill down by… Zoom inside this segment by steps or by another dimension.
Drill up Collapse this open segment.
Exploration method Change the exploration approach: Hierarchy or Top N.
Expand first driver Open the first driver of the step.
Add pillar / Remove pillar Add a total bar where you need a checkpoint, for example after a group of steps.
Filter on this Add story filters for this segment and its drill path. See Filters.
What if… Simulate a scenario on this element. See What-if scenarios.
Secondary comparison With several comparisons, place the second waterfall Above, On right or as an Overlay. See Comparison.

Hover a segment to see its variation, its mix and performance effects, and how it compares to the average of the step.

The tree shows the same breakdown as a tree: the KPI, its steps, then the segments that explain them. Use it to present the whole explanation at once.

The table gives the figures of the open hierarchy as numbers: values at Start and End, variations and impacts.

The comment summarises the analysis in a few sentences: the variation of the KPI, the step that drives it, and the segments that explain it. Its level of detail is set by Comment depth in the visual settings. See also Read the results.

Keys Action
Shift + W Switch to the waterfall
Shift + T Switch to the tree
Shift + R Reverse the axes of the waterfall or the tree
Shift + S Open the settings with the cursor in the search bar
Shift + M With a secondary comparison, merge or split the waterfalls on their common bars

All shortcuts: Keyboard shortcuts.