Side bar 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 | 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 sub groups |
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 |
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 for a chart
|
Legend Alias | Change legend display text |
Background Color | Change background of widget |
Legend Ordering | Legend ordering method, if applicable. |
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 |
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 |
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. 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 Title Text | Title for secondary Y-axis |
Secondary Data Label Formatter | For formatting; click [here](https://staging.knowi.com:9443/docs/labelformatting.html) |
Secondary Y-Axis Labels Formatter | For formatting; click [here](https://staging.knowi.com:9443/docs/labelformatting.html) |
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 |
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 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 |
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 X axis. The chart outputs the values in bars. The sub-group can have multiple levels of hierarchy of the parent bar group on the X-Axis. Enabling this functionality segregates the parent group into its children (sub groups) 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.