Waterfall Chart Node

Shows the cumulative effect of sequentially introduced positive or negative values. Useful for understanding how an initial value is affected by intermediate values, such as financial results over time.

What is a Waterfall Chart?

A waterfall chart is a specialized visual tool designed to illustrate the cumulative effect of sequentially occurring positive and negative changes in a dataset. Its primary purpose is to depict how values accumulate over time or through a series of events, displaying a running total as values are added or subtracted. This type of chart is particularly useful for analyzing financial data, highlighting the impact of various factors on a starting value. With its ability to show the flow of changes, a waterfall chart facilitates clear visualization of trends, allowing users to identify significant contributors to overall outcomes and understand the progression of data points in a concise and intuitive manner.

Inputs

The waterfall chart node has a mandatory input. This is:

Input

Requirement

Comments

X-Axis Field

Mandatory

(Only if Category is selected as the Column Type)

This is the field name within the incoming JSON payload that contains the data to be displayed on the widget.

How to Use

Implementation

In the Rayven Workflow Builder:

Select Visualizations.
Drag the Waterfall Chart node to the canvas.
Provide an input to the Waterfall Chart node by connecting it to another node.
Double click on the Waterfall Chart node to open the configuration window.

Configuration

Section: General
This section contains basic configuration elements required for any Waterfall Chart implementation
Field	Requirement	Comments
Widget Name	Mandatory	Enter a name for this node. This provides a handle to which you and others can refer, so it should be simple but meaningful and explain the node’s purpose.
Widget Subtitle	Optional	Additional text that can be used to explain the data presented by the node. This will appear directly under the Widget Name, in a smaller text size.
Direction Display	Mandatory	Select one of the following from the dropdown menu Vertical Horizontal
Device/Device Label Name	Mandatory	Select this checkbox to display the device or label name on the widget.
Function	Mandatory	Select one of the following from the dropdown menu Last value received Sum Average Min Max
Calculation Interval	Mandatory	Enter an integer to represent the interval for each calculation.
Units of Measurement	Mandatory	Select the units of measurement from the dropdown menu to be used for the interval calculations: Seconds Minutes Hours Days Weeks (Start from Monday) Weeks (Start from Sunday) Months Years For example, if the following is configured: X-axis time interval = 1 Units of measurement = Hour Function = average Then the chart will calculate the average value for each column for the hour.
Widget Refresh Interval (sec)	Optional	Configure how often the chart widget will refresh. The default is every 60 seconds.
Name of Y-Axis	Optional	Enter a name for the y-axis label.
Symbol	Optional	Enter a symbol that will be displayed at the end of the value.
Decimal Precision	Optional	Enter the number of decimal places to display for each field.
Range Min	Optional	Provide the minimum value for the y-axis.
Range Max	Optional	Provide the maximum value for the y-axis.
Column	Mandatory	To add a new row for columns, click on “+ Add Column” at the end of the general section.
Column Type	Mandatory	Select from the dropdown menu: Category Intermediate Sum Total Sum
X-Axis Field	Mandatory (Only if Category is selected as the Column Type)	This is the field name within the incoming JSON payload that contains the data to be displayed on the widget.
Name of X-Axis Category	Mandatory	Enter a name for the x-axis category.
Hex Color	Mandatory	Select a color for each field using a hex or RGB code. If no selection is made, a range of default colors will automatically be used.

Section: Tooltip Info
Field	Requirement	Comments
Show Tooltip	Optional	When checked, it allows users to display their tooltip text on the widget.
Tooltip Text	Optional	This section only exists when “Show Tooltip” is checked. Users are able to write any tooltip message they desire which will be displayed on the widget.

Section: Group by Device Label
Field	Requirement	Comments
Device label name	Mandatory	There are no labels available in this box until you have saved at least one in the Device Labels section of the Workspace. Select a Label to use to filter devices.
Grouped	Mandatory	Select a method for grouping the widget on the dashboard from the dropdown: No Grouping (widget per device): one widget will appear for each device Group by device label value (Widget per label value): One widget will appear for each value of a label. For example, if the Label is ‘Colour’ and there are the values ‘Green’ and ‘Gold’, then two widgets will be displayed, one with devices with Colour Label equal to “Green” and one with devices with Colour Label equal to “Gold” Group by device label name (One widget): Only one widget will be displayed and this will contain data from all devices.