A waterfall chart aids in understanding the cumulative effect of sequentially introduced positive or negative values. Example: Financial Analysis, Quarterly Gain/Loss, etc.
Chart Configuration
| Field |
Interpretation |
| Plot Data/Y-Axis |
Numeric Y-axis field to use. Leave it empty if for multiple Y-axis fields. |
| Y-Axis Categories |
Categories displayed vertically for a grid heatmap |
| Grouping/Legend |
Legend/series field if a column contains the fields. |
| X-Axis |
X-axis field if applicable. |
| X-Axis Type |
Set to date/time for a time series chart. |
| Show Total |
When checked, the total sum across the entire series will be displayed at the end |
| Intermediate sum |
When this property is set, the points act as a summary column for the values added or subtracted since the last intermediate sum |
| Y-Axis Max |
Optional max Y-axis value. Use it in conjunction with the tick interval to set the Y-axis labels. |
| Y-Axis Tick Interval |
Optional Y-axis tick interval to set the Y-axis labels. |
| Y-Axis Min |
Set the Y-axis minimum values |
| Grouping |
Grouping columns are shown next to each other |
| Y-Axis Logarithmic Scale Axis |
For log scale, enter logarithmic |
| Y-Axis Values in Reverse Order |
Check to reverse the axis so that the highest number is closest to the origin |
| Field |
Interpretation |
| Title Font Color |
Set the title font color of the widget |
| Title Font Size |
The default title font size is 14px. |
| Display Theme |
Select a theme for chart types |
| Colors |
To set and add color for a chart |
| Legend Alias |
Change legend display text |
| Background Color |
Change background of widget |
| Legend Show/Hide |
Display legend when enabled |
| Legend font size |
Font size of the legend |
| Reverse Legends |
To reverse the order of the legend items |
| Y-Axis Grid Line width |
Defaults to 1; set to 0 to hide grid lines |
| Column (bar) width |
Set the width for columns or bars in pixels |
| Field |
Interpretation |
| Display Y-Axis Title |
Display Y-axis title; enabled by default |
| Y-Axis Label Display |
Hide/show Y-axis labels |
| Y-Axis Title Text |
Title for Y-axis |
| X-Axis Title |
Title for X-axis |
| X-Axis Label Display |
Hide/show X-axis labels |
| X-Axis Label Rotation |
Degrees of rotation of X-axis labels; useful for long labels |
| X-Axis Date Formatter |
Override the default X axis date format. Only applicable for chart types with Date/time X axis. See formats here
|
| X-Axis labels format as data units |
Bytes, KB, MB, GB, etc. |
| Data Label Display |
Check to display value labels. Default is false |
| Data Label Font Size |
Enter font size, if the display label is set to true. Example: 15px. Defaults to 9px. |
| Data Label Formatter |
For formatting help click here
|
| Data Label Decimal Places |
Number of decimal places in data label |
| Symbol After Data Label |
Symbol to display after data label |
| Data Label Padding |
Set padding around data labels |
| Data Label Allow Overlap |
To allow data labels to overlap |
| Data Labels X Offset |
The X position offset of the label relative to the point in pixels |
| Hover Label Format |
For formatting help click here
|
| Data Labels Y Offset |
The Y position offset of the label relative to the point in pixels |
| Hover Decimal Places |
Number of decimal places to show on tooltip |
| Field |
Interpretation |
| Show Title |
Show Title on Widget |
| Analyze |
Show Analyze menu |
| Alerts |
Show Alert icon |
| Filters |
Show Filter icon |
| Drilldowns |
Show Drilldowns menu |
| Query |
Show Query menu |
| Data/Export |
Show Data/Export menu |
| Data Diagram |
Show Data Diagram |
| Share |
Show Share menu |
| Refresh |
Show Refresh menu |
| Maximize |
Show Maximize menu |
| Remove from Dashboard |
Show Remove from Dashboard menu |
Advanced Configuration
| Field |
Interpretation |
| Animation |
Animation of chart, ON by default |
| Time Series Navigator |
Enable/Disable time series navigator at the bottom of a time series chart; enabled by default |
| Polar |
To transform cartesian charts like line, spline, area and column into the polar coordinate system |
| Use UTC for Time Series Charts |
Disable auto browser conversion of Timezone for the time series charts and show UTC timestamps |
| X-Axis Ordinal |
Points are equally spaced in the chart regardless of the actual time or x distance between them |
| Change Dataset |
Change to a different dataset |
| On Click Event Handler |
Define custom javascript behavior when a point is clicked |