Versions Compared

Old Version 8

changes.mady.by.user Denise McGettigan

Saved on

compared with

New Version Current

changes.mady.by.user Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
The x axis depends on the mode. It displays period if you are in summary view. In variance mode it displays the selected dimension.
Info

Availability:

  • Summary view-Period mode only.

  • Focused view (when you select and focus on items in a dimension) - Variance mode only.

A waterfall chart gives you a visual overview of positive and negative changes to a value over a period of time. It is often used to gain insights into key processes within an area

(

, such as inventory

) and

. It is also used to assess financial performance

(e.g.

, for example, to build a step by step picture of growth or decline in cash flow

)

.

Waterfall charts are available in View a summary of the data and in Use Variance mode, and at least one dimension selected. Only one measure can be selected.

Table of Contents

Info
iconfalse
titleRelated topics

Accessing the waterfall chart

Choose Chart and select Bar > Waterfall.

Image Removed

What is displayed

  • The y axis displays the amount.

    • The benefit of a Waterfall chart over a Bar or Column chart is that you get to see each piece of the puzzle (see comparative images below).

    The following table describes what the Waterfall chart looks like in each view.

    Summary view

    Focused view

    Contents

    The first (left) column is always 'previous' and the last column (on the right) is always 'current'. These columns show the sum of values for the respective period, including any filters you have applied on the grid.

    For the columns in the middle, columns with positive values start at the height of the previous columns and go up proportionally to the variance; columns with negative values start at the height of the previous columns and go down proportionally to the variance. These also include any filters you have applied.

    X-axis

    The X-axis displays the time unit (month/day/year) of your current period. 

    The X-axis displays each focused item.

    Y-axis

    The Y-axis displays the total, which starts at zero.

    The Y-axis displays the total, which starts at zero.

    Example

    		Image Added

    		Image Added

    Example - Create a Waterfall chart

    In

    this example, the user is in summary view. They want an

    the Sales database, create a Waterfall chart to get a visual overview of results for the quarter Oct-Dec

    2017

    2022, compared with the same period in 2021.

    1. Prepare the data in the grid: In Period mode, in Summary view, apply a custom period

    in 2016. The benefit of selecting a waterfall chart over a bar or column chart is that you get to see each piece of the puzzle. For example, hovering on the bar for December shows you there was a 77% decline in revenue just for that month.

    Image Removed

    The same information in a column chart.

    Image Removed

    1. for the October to December quarter.

    2. Click the Chart button in the top right toolbar above the grid.

    3. Click the Bar chart category button on the left of the chart and select the Waterfall option.

      Image Added

    4. Hover over the columns to view the details. In this example, there was a 1.8% decline in revenue in December.

      Image Added

      If you view the same data in a Column chart, you can see how the Waterfall chart provides a clear picture of what’s happening.

      Image Added

    Related pages