Waterfall Chart
  • 27 Oct 2023
  • 1 Minute to read
  • Dark
    Light

Waterfall Chart

  • Dark
    Light

Article summary

Overview

A waterfall chart is a powerful visualization tool commonly used in finance, project management, and data analysis to display the incremental effect of different positive and negative values on a cumulative total. It helps you understand the flow of data, such as financial changes or project progress, from one point to another. We will walk you through the process of creating a waterfall chart.

image.png

Reference Content

The following articles may be useful resources as you build your chart:

Creating a Waterfall Chart

To create a waterfall chart, your data needs to resemble the following shape:

DimensionValue
Dimension A
Metric 1
Dimension BMetric 2
Dimension CMetric 3
Dimension D
Metric 4

Dimensions are the core way you want your metric to be grouped. Each value in a dimension will be a new "fall" in the waterfall chart.

Preset supports one additional grouping, called "Breakdowns" to further add additional segmentation and "falls" to the chart. To include Breakdowns, your data needs to resemble the following shape:

DimensionBreakdownValue
Dimension ABreakdown XMetric 1
Dimension BBreakdown XMetric 2
Dimension ABreakdown YMetric 3
Dimension BBreakdown YMetric 4

Waterfall Chart in Preset

If your data is already aggregated by stage, then you can select an aggregation that results in the values you want to show for each "fall"

Dimensions

  • Preset supports one value for Dimension. The unique values in this column will be used to group the Metrics to create each "fall" on the chart.

Metric

  • Ideally, the Metric columns starts as the unaggregated values from your dataset. Preset will then aggregate the values by each dimension for each "fall".

Breakdowns (Optional)

  • One additional column can be added for Breakdowns, which creates additional segmentation and "falls" in your chart.

Example chart

Using status as my dimension and sales as my metric, I can see visualize how the sales numbers with different statuses contributed to my total sales.



Was this article helpful?