Using a waterfall chart

Contents[Hide]

1. Overview

A waterfall chart displays the cumulative sum of a series of values as a specialized type of bar chart. It visualizes a measure's changes over a particular sequence, and well as its totals.

Tip
You can also use the new variance waterfall options in version 23.4 and higher.

2. Selecting data

A basic waterfall chart can have a single measure and a single hierarchy.

A basic waterfall chart
A basic waterfall chart

More complex displays are possible using multiple measures, or multiple hierarchies added to Columns (Series) in the Data Analysis Panel. Doing this will stack each set of values on each bar, showing how several component values affect the total.

Waterfall chart with columns hierarchy
Waterfall chart with columns hierarchy

2.1. Totals and aggregators

Total values are often displayed on Waterfall charts. To change which total values are included:

  • Check your metric set's Shown Totals setting and set it to Rows to display total bars, or else None. (The other options can result in adding a total series when data is added to Columns (Series) in the Data Analysis Panel, which is usually not used in waterfall charts.)
  • When displaying date/time data, the bottom axis scale type may have been set to Date/Time by default, which does not support displaying separate total bars. You can find Chart Properties in the toolbar and choose Category Axis to change the scale type in this case.
    Switching to a categorical axis
    Switching to a categorical axis
  • As the chart shows cumulative totals, the measure's aggregator should be set to Sum in the Data Analysis Panel. Using other aggregations may not display the desired result on the chart.
  • Subtotal bars will be displayed if there are multiple hierarchies or multiple levels selected on Rows in the Data Analysis Panel. To select multiple levels when using a multi-level hierarchy, set the Top Level, or you can drag the levels onto the chart from the Explore window.
    Waterfall chart with subtotals
    Waterfall chart with subtotals
  • To show or hide the grand total, see the Hide Grand Total property described next.

3. Properties

The grand total bar is hidden by default. To show it, un-check Hide Grand Total in the Properties window's Main tab for the chart.

Unchecking Hide Grand Total
Unchecking Hide Grand Total

A waterfall chart (sometimes called a 'bridge' chart) typically displays connecting lines bridging the end of one bar with the start of the next. They can be customized using the settings found in the series properties in the Look tab under Connecting Lines.

Customizing connecting lines
Customizing connecting lines

4. States

A common choice for waterfall charts is to visually distinguish between bars with positive versus negative values. This can be achieved by using states as shown in Set up states on a metric set.

Waterfall chart with states for positive, negative, and total values
Waterfall chart with states for positive, negative, and total values

Positive and/or negative states can compare against the constant value zero, while states identifying totals can compare against a hierarchy value of All.

Configuring the Grand Total state
Configuring the Grand Total state

5. Variance waterfall

You can have a variance waterfall set up for you automatically in version 23.4 and higher. For details, see Add variances.

Configuring the Grand Total state
Configuring the Grand Total state

6. See also

 

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri