Waterfall

This visualization is used to show some kind of a measure over a period of a year. The previous year is shown as a starting point. Then the visualization lists the numbers for each month or quarter, and ends with the total for the entire year.

The intermediate values can be either time-based or category-based. Consolidations are treated as subtotals.

The following example shows a typical waterfall visualization:

Waterfall visualization example

The following two options in the waterfall visualization significantly improve the user experience:

  • The Change the bar type as option in the bar right-click menu.

    Use this option to change the bar type to one of the following types: Auto, Delta, Adjustment, or Subtotal.

  • The Accumulate totals property under Visualizations > Data.

    Use this property to correctly render values from multiple Total bars in the visualization instead of changing the TM1 data.