Waterfall Chart
Liron Baram avatar
Written by Liron Baram
Updated over a week ago

Introduction

This article looks at Astrato's Waterfall visualization.

A Waterfall Chart data object consists of any number of measures.
The waterfall chart gives users a view of the cumulative value of the measure according to their orders.
Waterfall chart insights identify the significant contributors to the overall results.

Waterfall chart common use cases are:

  • Profit and Loss ledger.

  • Sales and Marketing funnel display

  • Actual vs. Target analysis by entities


Building a Waterfall

Add a Waterfall Chart

The waterfall Chart can be found in the visualization tile. It is positioned in the bar chart section of the visualization list.

Define a Waterfall Chart

  • Add as many measures as needed in the Data tab of the properties panel.

  • Special Measures Settings in the Waterfall Chart

    • Hide bar if zero or null: hide the measure from the charts if there is no data or the result is zero.

    • Sub-total: display the running total up to and including the measure as a bar on the right of the measure.
      give the sub-total bar a label in the input box.

    • Custom colors: override the chart color settings with settings for the measure.

  • Total Display -
    The total bar is a running total of all the measures in the chart.
    The total bar appears in the right side of the chart.
    The total bar number formatting is defined in the last measure in the chart.

Style a Waterfall Chart

  • Orientation: horizontal (default) or vertical

  • Bar padding: set the distance between the bars in the chart.

  • Bar radius: set the display of the bar corners.

  • Transparent bars: apply gradient and semi-transparent display for all bar colors.

  • Show lines: show connecting lines between the bars.

  • Color - set the general colors display for all different bar values.
    These settings can be overridden in measures individually

Did this answer your question?