Sidebar chart.
Chart 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 Min | Set the Y-axis minimum values |
| X-Axis Sub Groups (Beta) | To create multiple X-axis subgroups |
| Y-Axis Logarithmic Scale Axis | For log scale, enter logarithmic |
| 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. |
| Y-Axis Values in Reverse Order | Check to reverse the axis so that the highest number is closest to the origin. |
| Enable Stacking | Enable stacking for bar chart |
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. |
| Legend Show/Hide | Display legend when enabled |
| Legend font size | The 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 |
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 the 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 the 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 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. x-axis fields |
| Secondary Y-Axis Logarithmic Axis | For log scale, enter logarithmic |
| 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; enabled by default |
| Secondary Data Label Display | Display secondary value labels; default is false |
| 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; click here |
| Secondary Y-Axis Labels Formatter | For formatting; click here |
| Secondary Y-Axis Symbol Before Data Label | Symbol to display before data label for secondary Y-axis |
| Secondary Y-Axis Symbol After Data Label | Symbol to display after data label for secondary Y-axis |
| 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 | Click to reverse the 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 | Helps users format secondary chart display data. 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 |
|---|---|
| Animation | Animation of the 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 lines, splines, areas, and columns 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. |
| Use GPU Translations in Boost Mode | When in boost mode, GPU translations are faster than regular JS translations |
| Change Dataset | Change to a different dataset |
| On Click Event Handler | Define custom javascript behavior when a point is clicked |
Bar Chart Grouping
X-Axis Sub Groups
The sub-group allows you to add one or more bar levels or bar sub-grouping by the X axis. The chart outputs the values in bars. The sub-group can have multiple levels of the parent bar group hierarchy on the X-Axis. Enabling this functionality segregates the parent group into its children (subgroups) with respect to the legends.
Example:
In the bar visualization below, you can observe how the parent group - "Continent," is divided into "Country", and how the "Country" is subdivided into "City," with all of them sub-grouped together.
Note 1: If you select "Date/Time" from the X-Axis Type, then the "X-Axis Sub Groups" field will not be visible in the interface.
Note 2: You can also perform the sub-groups functionality in the Column and Stacked Column visualization.
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)\$