Curation - Waterfall Chart | AO Platform

Intended audience: end-users analysts developers administrators

AO Platform: 4.4

Overview

This section offers an overview of the Waterfall Chart for a Curation Micro Application. A Waterfall Chart is a powerful visualization tool used to display the cumulative effect of sequential positive and negative values on a starting point.

Example

Configuration of Waterfall Chart

DATA Properties

Label	UI Widget	Default	Description
X-Axis Field	Dropdown w/Expression option		The X-axis Field allows users to select the MSO Field Property to represent the X-axis values in the Chart.
Show Series Data in Row	ON/OFF Toggle	OFF	If enabled, select a single Series Type and Series Field below. If disabled, select one or more Series Fields below.
Series Fields	Repeater Dropdown w/Additional Properties, Expression, and Color options		The Series Fields allow users to select an MSO Field Property to represent the Series Field.
… Active	ON/OFF Toggle	ON	If enabled, the feature or data series is active and will be applied or shown in the column chart.
… Use Series Field to Apply Data Styles	ON/OFF Toggle	OFF	The ON/OFF toggle refers to enabling or disabling the application of data styles to the series field.
… Series Name	Text Field		The Series Name allows users to enter Series Names that will be used to identify the data Series in the Legend.
… Y-Axis Name	Text Field		The Y-Axis Name field displays the name of Y-Axis.
… Exclude Zero Values	ON/OFF Toggle	OFF	If enabled, zero values will be excluded. By default, this setting is disabled.
… Additional Properties	Key / Value - Text Fields		Optional Additional Properties - expressed as a Key/Value pair.
Series Type Field	Dropdown w/Expression option		The Series Type Field dropdown in area chart curation allows users to specify a field that determines the type of series displayed in the chart.
Series Field	Dropdown w/Additional Properties and Expression options		The Series Fields allow users to select an MSO Field Property to represent the Series Field.
Positive Value Color	Text Field w/Color Palette option		The Positive Value Colors allows users to select which color to use for the area of the series. See Curation - Field Properties - Data Styles.
Negative Value Color	Text Field w/Color Palette option		The Neative Value Colors allows user to select which color to use for the area of the series. See Curation - Field Properties - Data Styles.
Max no. of records	Number Field		Option to set a Max number of records to be used by the Chart.
Sort By Field	Dropdown w/Expression option		The Sort By Field option allows users to select a field to sort the data and also provides the flexibility to define a custom expression for more advanced sorting criteria.
Sort Direction	Dropdown		Option to set the Sort order for data in the Chart to either Ascending or Descending.
Base Series	Dropdown		The dropdown Base Series field allows users to select an option relating to each series Field, such as Bell Curve, Histogram, Pareto.
Apply when shown from a Connected MSO	ON/OFF Toggle	OFF	The Apply When Shown from a Connected MSO ON/OFF Toggle determines whether the settings or actions are applied specifically when data is displayed through a connected MSO. ON: The feature or behavior is applied when the data originates from the connected MSO. OFF: The feature or behavior is not applied, regardless of the connected MSO.
Apply Curation Data Size for the App Data	ON/OFF Toggle	OFF	If enabled, the Record Count rules will be applied. If the Record Count rules are not met, the series will not be shown.
Show TopN plus Other	ON/OFF Toggle	OFF	If Show TopN plus Other enabled, the App will display only the Top N records along with a single aggregated category representing all other records. The number of records shown for the Top N is determined by an MSO Setting in the Easy Answers section. If disabled, the App will display all records based on the user's query.
Show All Records on Data Tab and in Data Download	ON/OFF Toggle	OFF
Additional Tooltip Data Properties	Display Name - Text Field MSO Property - Dropdown		The Additional Tooltip Data Properties allow users to select one or more MSO Field Properties to display their values in the tooltip when the user hovers over a data point.

AXIS Properties

Label	UI Widget	Default	Description
X-Axis Type	Dropdown		Option to select the format of the X-Axis, including: Linear, Logarithmic, DateTime, Category, Color, BellCurve.
Add Reference Links in X-Axis Label	ON/OFF Toggle	OFF	If enabled, X-Axis labels will be converted into clickable links, with their content defined by the JavaScript in the Link JS Function. When disabled, the labels will not include links.
Link JS Functions			The Link JS function allows users to select from an existing JavaScript Function to be used to generate links for the X-Axis Labels
Show Axis Titles	ON/OFF Toggle	OFF	If enabled, titles can be added to both the X-Axis and Y-Axis. If disabled, the X-Axis and Y-Axis will not have titles.
X-Axis Title	Text Field
Y-Axis Title	Text Field
Additional Properties	Text Fields		Repeater section of Key and Value pairs

DATA LABELS Properties

Label	UI Widget	Default	Description
None/Percentage/Value	Dropdown w/Additional Properties option	Show Percentage	Optional Additional Properties - expressed as a Key/Value pair.
… Additional Properties			Optional Additional Properties - expressed as a Key/Value pair.
Data Label JS Function	Text Field w/Search		The Data Label JS function allows users to search for and define JavaScript functions that control the display or behavior of data labels in a chart.
Lazy Load Data Labels	ON/OFF Toggle	OFF	If enabled, in the Waterfall Chart, curation controls whether data labels are loaded gradually as the chart is interacted.

EVENTS Properties

Label	UI Widget	Default	Description
On Click JS Function	Text Field w/Search
On Double Click JS Function	Text Field w/Search
On Chart Load JS Function	Text Field w/Search
Data Param JS Function	Text Field w/Search

Label	UI Widget	Default	Description
Show Tooltip	ON/OFF Toggle	ON
Show X-Axis Name in Tooltip	ON/OFF Toggle	OFF	If enabled, the tooltip displayed when hovering over data in the App will include the X-Axis name. If disabled, only the data value will be shown, without the X-Axis name
Additional Tooltip Properties	Key / Value - Text Fields		Optional Additional Tooltip Properties - expressed as a Key/Value pair.

STYLES Properties

Label	UI Widget	Default	Description
Disable Animation	ON/OFF Toggle		The Disable Animation toggle refers to turning off any animated transitions or effects that occur when the chart or visualization is rendered or updated.

Contact App Orchid | Disclaimer