Field Definition

Use

Defines the X-axis values for the chart bar or column. The data must have a STRING base type. Each row is displayed as a category on the X-axis. The defined name for this column is the option that you should select for the XAaxisField widget property.

Defines the Y-axis value and the legend label for the category.

Defines the Y-axis value and the legend label for each additional data series.

Waterfall Chart supports non selectable bars. This means you can hover over and focus on the bars in the chart but cannot select it.

You must create an additional column Selectable in the infotable data source. The values or bars are interactive and set to True by default. You may set the value to False to make the bar non selectable. The field is not case sensitive. The NonSelectableData property in the properties list controls whether the user can click to select the data on the chart. For more information, see the property table.

Defines whether an increase or decrease in the value is displayed as a stacked or overlapped bar over a full bar in the chart. The value is set to False by default. You may set the value to True to display the stacked or overlapped bars.

You must create an additional column ShowTotal in the infotable data source. The field is not case sensitive. The ShowTotal property in the properties list controls whether the bars appear stacked or overlapped. For more information, see the property table.

Base Type

STRING

NUMBER

NUMBER

BOOLEAN

BOOLEAN

Row Example

Game:'Cash In'—Where Cash In is the category name to show on the X-axis

Player1:100—The Y-axis value for the category

Player2: 100 — The Y-axis value for the second data series

For example, see the image for multi series data below.

For example, see the image for single series data below.

Adds a secondary Y-axis to the chart.

When you select this property, SecondYAxisFormat, SecondYAxisLabel, and SecondYAxisLabelAlignment properties appear on the list.

BOOLEAN

False

Y

N

Specifies the text label for the secondary Y-axis.

STRING

Secondary Y-axis

Y

Y

Aligns the label for the secondary Y-axis. You can position the label at the Top, Middle, or Bottom. By default, the label is positioned in the middle.

STRING

Middle

N

N

Sets the format for the secondary Y-axis values. You can use this property to determine how the displayed data looks. For example, you can set the number of digits to display after the decimal point.

STRING

0000.0

Y

N

Species the number of data points to display on the chart.

NUMBER

n/a

N

N

Shows zoom in and out buttons on the chart toolbar when horizontal or vertical zoom is enabled.

BOOLEAN

False

N

N

Specifies the icon to display when the chart is empty.

Media Entity

N

N

Specifies the text to display when the chart is empty.

STRING

N

Y

Specifies the icon to display when the chart is empty.

Media Entity

N

N

Specifies the text to display when the chart is empty.

STRING

N

Y

Specifies the icon to display when the chart data is loading.

Media Entity

N

N

Specifies the icon to display when the chart is not bound to a data source.

Media Entity

N

N

Specifies the text to display when the chart is not bound to a data source.

STRING

N

Y

The user defined CSS class to apply to the top div of the widget.

Multiple classes can be entered, separated by space.

STRING

n/a

Y

N

The infotable data source for the chart.

INFOTABLE

n/a

Y

N

DataField1 — DataField24

These properties are listed when you set NumberOfSeries to a fixed number. You can use these properties to select the infotable column to use for each data series.

Infotable Column

n/a

N

N

DataLabel1 — DataLabel24

These properties are listed when you set NumberOfSeries to a fixed number. This property sets the label text that is displayed in the legends area for the respective data series.

STRING

n/a

Y

N

Opens the state formatting configuration dialog box. This property appears when NumberOfSeries is set to Auto. The state definition is applied to all series on the chart. You can style the series based on data values to spot trends and patterns more easily.

State Definition

n/a

N

N

DataSeriesStyle1 — DataSereisStyle24

These properties are listed based on the number that you set for the NumberOfSeries property. You can use these properties to apply a separate state definition to each data series on the chart.

State Definition

n/a

N

N

Disables the widget in the mashup.

The widget is displayed in the mashup but you cannot click or select it.

BOOLEAN

False

Y

N

Allows you to zoom in by selecting two data items on the chart.

The options that are available to you for this property are Horizontal Axis, Vertical Axis, Both, and None.

This property appears on the properties list when you select HorizontalZoom

STRING

None

Y

N

Allows you to zoom in to a specific part of the chart by drawing a selection box around the data range that you want to view.

The options that are available to you for this property are Horizontal Axis, Vertical Axis, Both, and None.

This property appears on the properties list when you select HorizontalZoom

STRING

None

Y

N

Sets the padding from the axes.

Padding value is a percentage of the bar width.

NUMBER

25

Y

N

Hides the connector lines used to highlight the change between each value in the data sequence.

BOOLEAN

False

Y

N

Hides tooltips that are displayed on hovering or selecting a data point on the chart.

BOOLEAN

False

N

N

Hides the legend area.

When you select this property, the LegendAlignment, LegendFilter, LegendMarkerShapes, LegendMaxWidth, and LegendPosition properties do not appear on the properties list.

BOOLEAN

False

Y

N

Hides the notes area.

When you select this property, the Notes, NotesAlignment, and NotesPosition properties do not appear on the properties list.

BOOLEAN

False

Y

N

Hides the X-Axis.

BOOLEAN

False

Y

N

Hides the Y-Axis.

BOOLEAN

False

Y

N

Sets the rotation angle of labels on the horizontal axis. You can enter a value from — 180 to 180.

NUMBER

Autosize

N

N

Sets a maximum height for the horizontal axis.

NUMBER

85

Y

N

Allows you to zoom in on the horizontal axis.

When you select this property, the HorizontalRangeZoom, HorizontalSliderZoom, DirectSelectionZoom, and DragSelectionZoom properties appear on the properties list.

BOOLEAN

False

Y

N

Adds controls that allow you to specify a value range to zoom in on the horizontal axis.

When you select this property, the following HorizontalStartZoomLabel and HorizontalEndZoomLabel properties appear on the properties list.

BOOLEAN

False

Y

N

Sets the date format within the date selection box when using a range selection zoom.

STRING

n/a

N

N

Sets the width of the date selection box on the horizontal axis when zooming is enabled.

NUMBER

332px

N

N

Specifies the text label for the start of the range selection.

STRING

n/a

Y

Y

Specifies the text label for the end of the range selection.

STRING

n/a

Y

Y

Adds a slider control that allows you to display data between a minimum and a maximum value on the horizontal axis.

When you select this property, the HorizontalSliderZoomMaxLabel and HorizontalSliderZoomMinLabel properties appear on the properties list.

BOOLEAN

False

Y

N

Specifies the label for the maximum value of the slider zoom control.

STRING

n/a

Y

Y

Specifies the label for the minimum value of the slider zoom control.

STRING

n/a

Y

Y

Sets the padding between the series of data.

Padding is a percentage of the bar width.

NUMBER

25

Y

N

Displays the label text for the Waterfall Chart.

STRING

Waterfall Chart

Y

Y

Selects the label type for the Waterfall Chart as Large Header, Header, Sub-Header, Large Title, Title, Label, Body, or Caption.

STRING

Sub-Header

Y

N

Aligns the label of the Waterfall Chart widget to the Left, Center, or Right.

STRING

Left

N

N

Sets the position of the label at the Top or Bottom.

STRING

Top

N

N

Sets the label that is displayed in the reset button for the zooming control.

STRING

Reset

Y

Y

Aligns the legend text to the Top, Middle, or Bottom.

The options that are available to you for this property depend on the setting of the LegendPosition property.

STRING

Top

N

N

Adds a legend filter that allows the user to filter the chart at runtime.

BOOLEAN

False

N

N

Sets the marker shape of the legend as Square, Circle, or None.

STRING

Square

N

N

Sets a maximum width for the legend area.

NUMBER

736

Y

N

Sets the position of the legend at the Top, Bottom, Left, or Right.

STRING

Right

N

N

Uses True or False values from the selectable infotable field to control whether users can click to select data on the chart. Each value within the field applies to all data series on the same row.

BOOLEAN

False

N

N

Specifies the text to display within the notes area on the chart. You can enter a string or select a localization token.

STRING

n/a

Y

Y

Aligns the note text to the Left, Right, or Center within the notes area.

STRING

Left

N

N

Sets the position of the notes area at the Top or Bottom.

STRING

Bottom

N

N

Sets the number of reference lines to display on the chart.

Reference lines are used to highlight the chart data relative to a specific value. You can add up to 24 lines and configure the label, axis, and value of each line.

For example, when you set a value from 1–24 to this property, corresponding properties ReferenceLine1Label — ReferenceLine24Label and ReferenceLine1Value — ReferenceLine24Value appear on the properties list.

NUMBER

0

N

N

Sets the number of data series to display on the chart.

Automatic setting displays all data series.

NUMBER

Auto

N

N

Sets the number of labels to display on the Y axis.

NUMBER

Auto

N

N

Specifies the orientation of the chart. You can display the cumulative change along a horizontal or vertical axis.

STRING

Vertical

N

N

Resets the input for this widget to the default values.

n/a

n/a

Y

N

Shows the rulers in front of the data values. By default, the rulers are displayed behind the data.

BOOLEAN

False

Y

N

Triggers an event when you click on a data point.

n/a

n/a

Y

N

An infotable that contains the selected data on the chart.

INFOTABLE

n/a

Y

N

Controls how many data points a user can select at the same time.

The options are Single, Multiple, and Default.

Choose Multiple to allow a user to select more than one data point.

STRING

Default

Y

N

Adds a show/hide button that enables you to show or hide the chart legend at run time.

BOOLEAN

False

N

N

Use True or False values under the ShowTotal infotable field to control whether trend values are displayed relative to a full bar or column. When set to True, additions are stacked and subtractions overlap the bar or column using a different color.

BOOLEAN

False

N

N

Shows the values labels on the chart.

When you select this property, ValuesPosition property appears on the list.

BOOLEAN

False

Y

N

Shows the X-Axis ruler.

BOOLEAN

False

Y

N

Shows the Y-Axis ruler.

BOOLEAN

False

Y

N

Shows the zero value ruler.

BOOLEAN

False

Y

N

Shows zoom in and out buttons on the chart toolbar when horizontal or vertical zoom is enabled.

BOOLEAN

False

N

N

Shows a simplified view of the chart visualization. Enable this property to hide labels, legends, and rulers.

BOOLEAN

False

Y

N

The sequence number of the Waterfall Chart widget when you press the TAB.

NUMBER

n/a

N

N

Highlights trends using different colors when the chart displays data from one series.

BOOLEAN

False

Y

N

Allows you to display a custom tooltip when a data point is selected.

You can show a title, text, data values, and create new lines. Use the following syntax: Add #title# before a string to show a title, #newline# to create a new line, ${<token_name>} to display data from available chart tokens, and ${Data:<infotable_column>} or ${DataSourceN:<infotable_column>} to display values from an infotable column. Add a ${total} token to display the total and enclose the token in #step# to display the total for steps only. For example: #title#Tooltip Title#newline#${label},${total}#newline#${data:Column3}#step#${total} in total#step#.

STRING

WaterfallChartDefaultTooltip

Y

N

Sets the position of the data value labels relative to the chart bars as Outside bar or Overlap bar.

STRING

Outside bar

N

N

Sets a maximum width for the vertical axis.

NUMBER

85

Y

N

Allows you to zoom in on the vertical axis.

When you select this property, a VerticalSliderZoom property appears on the properties list.

BOOLEAN

False

Y

N

Adds a slider control that allows you to display data between a minimum and a maximum value on the vertical axis.

When you select this property, the VerticalZoomMaxLabel and VerticalZoomMinLabel properties appear on the properties list.

BOOLEAN

False

Y

N

Specifies the text label for the maximum value of the slider zoom control.

STRING

n/a

Y

Y

Specifies the text label for the minimum value of the slider zoom control.

STRING

n/a

Y

Y

Infotable field that represents the data for the X-Axis.

INFOTABLE

n/a

N

N

Displays the text label for the X-Axis.

STRING

X-axis

Y

Y

Aligns the X-Axis label to the Left, Center, or Right.

STRING

Center

N

N

Sets the format for the Y-Axis values.

STRING

0000.0

Y

N

Displays the text label for the Y-Axis.

STRING

Y-axis

Y

Y

Aligns the Y-Axis label to the Top, Middle, or Bottom.

STRING

Middle

N

N

Sets the maximum range for the Y-Axis values.

Be default, the range is automatically calculated based on the widget data. The value for this property is ignored if the chart data contains a larger value.

STRING

n/a

Y

N

Sets the minimum range for the Y-Axis values.

By default, the range is automatically calculated based on the widget data. The value for this property is ignored if the chart data contains a smaller value.

STRING

n/a

Y

N