XY chart that plots each data point as a marker.
Widget Configuration
| Field | Interpretation |
|---|---|
| Plot Data/Y-Axis | Numeric Y-axis field to use. Leave it empty if for multiple Y-axis fields. |
| Grouping/Legend | Legend/series field if a column contains the fields. |
| X-Axis | X-axis field if applicable. |
| X-Axis Ordering | Optional X-axis data ordering if applicable. |
| X-Axis Type | Set to date/time for a time series chart. |
| 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. |
| Target Line | The optional value for the target line only applies to the primary Y-axis. |
| Y-Axis Soft Max | If the series data maximum is less than this, the axis will stay at this maximum, but if the series data maximum is higher, the axis will flex to show the data. |
Display & Formatting
| 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 to a chart
|
| Legend Alias | Change legend display text |
| Background Color | Change the background of the widget |
| Legend Ordering | Legend ordering method, if applicable. |
Widget Labels
| 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 |
| Hover Date Formatter | Override the default Hover date format. Only applicable for chart types with Date/time X axis. Example: YYYY-MM-DD h:m:s would be displayed as 2021-10-01 01:10:15. 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 |
| Y-Axis Labels Formatter | For formatting help |
| 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 |
| 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 |
Secondary Chart Configuration
| Field | Interpretation |
|---|---|
| Secondary Y-Axis | Optional secondary Y-axis on the right-hand side of the chart. |
| Secondary chart type | Chart type for the secondary chart. |
| Secondary chart grouping | Display a second stacking groups on the X-axis based on the string field selected. |
| Synchronize Y-axis Ticks | Align primary and secondary chart axis tick marks. |
| Secondary Chart Send to Back | Adjusts (z-index) to send the secondary chart behind the first. |
| Synchronize Y-Axis values |
Synchronizes the Y-axis primary and secondary to the same values. |
| Secondary Y-Axis Max |
Set the Y-Axis Max values for the secondary Y-Axis. |
| Secondary Y-Axis Min |
Set the Y-Axis Min values for the secondary Y-Axis. |
Secondary Chart Display
| Field | Interpretation |
|---|---|
| Secondary Y-Axis Title Display | Display secondary Y-Axis title. Enabled by default. |
| Secondary Data Label Display | Check to display secondary value labels. |
| Secondary Y-Axis Label Display | Show/Hide the secondary Y-axis values. |
| Secondary Y-Axis Title Text | Title for secondary Y-Axis |
| Secondary Data Label Formatter | For formatting help click here |
| Secondary Y-Axis Labels Formatter | For formatting help click here |
| Secondary Y-Axis Symbol Before Data Label | Symbol to display before data label for Secondary Y-axis (e.g. $) |
| Secondary Y-Axis Symbol After Data Label | Symbol to display after data label for Secondary Y-axis (e.g. %) |
| Secondary Data Label Decimal Places | Number of decimal places in data label for Secondary Y-axis. |
| Secondary Data Labels X Offset | The x position offset of the label relative to the point in pixels. |
| Secondary Y-Axis Value in Reverse Order | Check to reverse the secondary axis so that the highest number is closest to the origin. |
| Secondary Data Labels Y Offset | The y position offset of the label relative to the point in pixels. |
| Secondary Hover Label Format | For formatting help click here |
Widget Menu
| 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 the Dashboard menu |
Advanced Configuration
| Field | Interpretation |
|---|---|
| Change Dataset | Change to a different dataset |
| On Click Event Handler | Define custom javascript behavior when a point is clicked |
Using Runtime tokens
Users can use runtime tokens in charts to dynamically pull data. Runtime tokens are supported in: Widget title, footnote, description, and some fields in the primary and secondary charts. Those fields are: Y-minimum, Y-maximum, Y-axis tick interval, Y-axis title text, X-axis title text, Data Label Formatter, and Hover Label Formatter.
The basic syntax to use a runtime token is \$c9_YourTokenName\$(label)\$
For example:
For a dynamic title: \$c9_myToken\$(Your Title)\$
For integer values: \$c9_myToken\$(500)\$