Chart Advanced Features: Doughnut 3D
The following sections provide a list of available advanced attributes available for controlling and customizing 3D Doughnut chart elements.
This topic contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. These topics were converted directly from the documentation provided by this third-party source. Not every attribute listed may be supported in Exago BI as some unexpected conflicts may occur in their integration within the application.
Functional Attributes
These attributes let you control a variety of functional elements on the chart. For example, you can opt to show/hide data labels, data values etc. You can also set chart limits and extended properties.
Attribute | Type | Value | Description |
---|---|---|---|
animation | True/False | 0/1 | This attribute gives you the option to control animation in your charts. If you do not want to animate any part of the chart, set this as 0. |
animationDuration | Number | In seconds | This attribute sets the animation duration of the chart. `animationDuration` attribute is applicable only if animation of the chart is enabled. Default value: 1 sec |
animateClockwise | True/False | 0/1 | Animates the plot in clockwise direction, if `alphaAnimation` attribute is set to `0` Default value: 0 |
alphaAnimation | True/False | 0/1 | Instead of rotational animation, you can set alpha animation which displays your chart slowly from `0` alpha to `100`. Default value : 1 |
palette | Number | 1-5 | Exago BI uses the concept of Color Palettes. Each chart has 5 pre-defined color palettes which you can choose from. Each palette renders the chart in a different color theme. |
paletteColors | Text | List of hex color codes separated by comma | While the `palette` attribute allows to select a palette theme that applies to chart background, canvas, font and tool-tips, it does not change the colors of data items (that is, column, line, pie etc.). Using `paletteColors` attribute, you can specify your custom list of hex colors for the data items. The list of colors have to be separated by comma for example, `”paletteColors”: “#FF0000, #0372AB, #FF5904…”`. The chart will cycle through the list of specified colors and then render the data plot accordingly. To use the same set of colors throughout all your charts in a web application, you can store the list of palette colors in your application globally and then provide the same in each chart JSON. |
showZeroPies | True/False | 0/1 | Configuration whether to show pies with 0 values (and their values). Otherwise, they won’t show up in the chart. |
showPercentValues | True/False | 0/1 | Whether to show percentage values in labels of the chart. |
showPercentInToolTip | True/False | 0/1 | Whether to show percentage values in tool tip. |
showLabels | True/False | 0/1 | Whether to show labels on the chart. |
showValues | True/False | 0/1 | Whether to show values on the chart. |
labelSepChar | Text | Character | The character to separate the data label and data values on the chart. |
clickURL | Text | Any | The entire chart can now act as a hotspot. Use this URL to define the hotspot link for the chart. The link can be specified in Exago BI Link format. |
clickURLOverridesPlotLinks | True/False | 0/1 | Sets whether the `clickURL` attribute (that sets a link to which the user is directed when the chart is clicked) overrides the `link` attribute (that sets a link to which the user is directed when a data plot is clicked). Default value: 0 (`clickURL` does not override `link`) |
useDataPlotColorForLabels | True/False | 0/1 | Uses the same data plot color for data labels. |
hasRTLText | Number | Any | This attribute, when set to `1`, indicates to the chart that the text (rendered on the chart) may contain RTL characters and the textual display has to be managed accordingly. |
plotHighlightEffect | Text | Any | This attribute lets you enable/disable the highlight effect, in the form of a `fadeout`, for the data plots corresponding to a legend item. When this attribute is enabled and the mouse pointer is hovered over a legend item label, plots belonging to the other data series fadeout, by reducing their opacity. The fadeout effect can be customized by specifying the fadeout color and opacity using the `color` and `alpha` attributes. for example . `fadeout|color=#ff0000, alpha=60` |
showPrintMenuItem | True/False | 0/1 | Whether to show “Print Chart” item in the context menu of the chart? Even if you opt to hide the item in context menu, you can still opt to invoke `print()` JavaScript method of the chart to print the same. |
theme | Text | ‘fusion’, ‘gammel’, ‘candy’, ‘ocean’, ‘zune’, ‘carbon’, ‘umber’ | This attribute changes the theme of the chart. There are 7 types of themes which have been made according to the different color combinations. |
Chart Message-related Attributes
These attributes let you set and configure custom chart messages, using text as well as images.
Attribute | Type | Value | Description |
---|---|---|---|
baseChartMessageFont | Text | Any | This attribute allows to set a custom font for all chart messages. |
baseChartMessageFontSize | Number | In pixels | This attribute allows to set a custom font size for all chart messages. |
baseChartMessageColor | Color | Hex Color Code | This attribute allows to set a custom font color for all chart messages. |
baseChartMessageImageHAlign | Text | left, middle, right | This attribute allows to set a custom horizontal alignment for all images displayed as chart messages. Default value: middle |
baseChartMessageImageVAlign | Text | top, middle, bottom | This attribute allows to set a custom vertical alignment for all images displayed as chart messages. Default value: middle |
baseChartMessageImageAlpha | Number | 0 – 100 | This attribute allows to set a transparency for all images displayed as chart messages. Default value: 100 |
baseChartMessageImageScale | Number | 0-300 | This attribute allows to set a scale for magnifying all images displayed as chart messages. Default value: 100 |
loadMessage | Text | Any | This attribute allows to set the message to be displayed when a chart begins to load. To display an image as the chart message, prefix `I-` to the image URL. |
loadMessageFont | Text | Font Name | This attribute allows to set the font for the message displayed when a chart begins to load. |
loadMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed when a chart begins to load. |
loadMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed when a chart begins to load. |
loadMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `loadMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
loadMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `loadMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
loadMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `loadMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
loadMessageImageScale | Number | 0-300 | If an image is displayed as the chart `loadMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
typeNotSupportedMessage | Text | Any | This attribute allows to set the message to be displayed when the specified chart type is not supported. To display an image as the chart message, prefix `I-` to the image URL. |
typeNotSupportedMessageFont | Text | Font Name | This attribute allows to set the font for the message displayed when the specified chart type is not supported. |
typeNotSupportedMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed when the specified chart type is not supported. |
typeNotSupportedMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed when the specified chart type is not supported. |
typeNotSupportedMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `typeNotSupportedMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
typeNotSupportedMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `typeNotSupportedMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
typeNotSupportedMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `typeNotSupportedMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
typeNotSupportedMessageImageScale | Number | 0-300 | If an image is displayed as the chart `typeNotSupportedMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
renderErrorMessage | Text | Any | This attribute allows to set the message to be displayed if an error is encountered while rendering the chart. To display an image as the chart message, prefix `I-` to the image URL. |
renderErrorMessageFont | Text | Font Name | This attribute allows to set a font for the message displayed if an error is encountered while rendering the chart. |
renderErrorMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed if an error is encountered while rendering the chart. |
renderErrorMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed if an error is encountered while rendering the chart. |
renderErrorMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `renderErrorMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
renderErrorMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `renderErrorMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
renderErrorMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `renderErrorMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
renderErrorMessageImageScale | Number | 0-300 | If an image is displayed as the chart `renderErrorMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
dataLoadStartMessage | Text | Any | This attribute allows to set the message to be displayed when chart data begins loading. To display an image as the chart message, prefix `I-` to the image URL. |
dataLoadStartMessageFont | Text | Font Name | This attribute allows to set a font for the message displayed when chart data begins loading. |
dataLoadStartMessageFontSize | Text | In pixels | This attribute allows to set the font size for the message displayed when chart data begins loading. |
dataLoadStartMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed when chart data begins loading. |
dataLoadStartMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `dataLoadStartMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
dataLoadStartMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `dataLoadStartMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
dataLoadStartMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `dataLoadStartMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
dataLoadStartMessageImageScale | Number | 0-300 | If an image is displayed as the chart `dataLoadStartMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
dataEmptyMessage | Text | Any | This attribute allows to set the message to be displayed if the data loaded for a chart is empty. To display an image as the chart message, prefix `I-` to the image URL. |
dataEmptyMessageFont | Text | Font Name | This attribute allows to set the font for the message displayed if the data loaded for a chart is empty |
dataEmptyMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed if the data loaded for a chart is empty. |
dataEmptyMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed if the data loaded for a chart is empty. |
dataEmptyMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `dataEmptyMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
dataEmptyMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `dataEmptyMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
dataEmptyMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `dataEmptyMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
dataEmptyMessageImageScale | Number | 0-300 | If an image is displayed as the chart `dataEmptyMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
dataLoadErrorMessage | Text | Any | This attribute allows to set the message to be displayed if an error is encountered while loading chart data. To display an image as the chart message, prefix `I-` to the image URL. |
dataLoadErrorMessageFont | Text | Font Name | This attribute allows to set a font for the message displayed if an error is encountered while loading chart data. |
dataLoadErrorMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed if an error is encountered while loading chart data. |
dataLoadErrorMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed if an error is encountered while loading chart data. |
dataLoadErrorMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `dataLoadErrorMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
dataLoadErrorMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `dataLoadErrorMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
dataLoadErrorMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `dataLoadErrorMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
dataLoadErrorMessageImageScale | Number | 0-300 | If an image is displayed as the chart `dataLoadErrorMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
dataInvalidMessage | Text | Any | This attribute allows to set the message to be displayed if the data to be loaded for the chart is invalid. To display an image as the chart message, prefix `I-` to the image URL. |
dataInvalidMessageFont | Text | Font Name | This attribute allows to set the font for the message displayed if the specified chart data is invalid. |
dataInvalidMessageFontSize | Number | In pixels | This attribute allows to set the font size for the message displayed if the specified chart data is invalid. |
dataInvalidMessageColor | Color | Hex Color Code | This attribute allows to set the font color for the message displayed if the specified chart data is invalid. |
dataInvalidMessageImageHAlign | Text | left, middle, right | If an image is displayed as the chart `dataInvalidMessage`, this attribute allows to set a custom horizontal alignment for the image. Default value: value assigned to the `baseChartMessageImageHAlign` attribute |
dataInvalidMessageImageVAlign | Text | top, middle, bottom | If an image is displayed as the chart `dataInvalidMessage`, this attribute allows to set a custom vertical alignment for the image. Default value: value assigned to the `baseChartMessageImageVAlign` attribute |
dataInvalidMessageImageAlpha | Number | 0 – 100 | If an image is displayed as the chart `dataInvalidMessage`, this attribute allows to set the transparency of the image. Default value: 100 |
dataInvalidMessageImageScale | Number | 0-300 | If an image is displayed as the chart `dataInvalidMessage`, this attribute allows to set the scale for magnifying the image. Default value: 100 |
Chart Titles
Using these attributes, you can set the various headings and titles of chart like caption and sub-caption.
Attribute | Type | Value | Description |
---|---|---|---|
caption | Text | Any | Caption of the chart. |
subCaption | Text | Any | Sub-caption of the chart. |
Chart Caption Cosmetics
These attributes let you configure the cosmetics of chart caption and sub-caption.
Attribute | Type | Value | Description |
---|---|---|---|
captionAlignment | Text | “left”, “center”, “right” | Sets horizontal alignment of caption |
captionOnTop | True/False | 0/1 | Whether caption should be on top of the data plot area |
captionFontSize | Number | 6 – 72 | Sets the caption font size in pixels |
subCaptionFontSize | Number | 6 – 72 | Sets the sub-caption font size (in pixels) |
captionFont | Text | Font Name | Sets the caption font family |
subCaptionFont | Text | Font Name | Sets the sub-caption font family |
captionFontColor | Color | Hex Color Code | Sets the caption font color |
subCaptionFontColor | Color | Hex Color Code | Sets the sub-caption font color |
captionFontBold | True/False | 0/1 | Whether the caption font should be displayed in bold |
subCaptionFontBold | True/False | 0/1 | Whether the sub caption font should be displayed in bold |
alignCaptionWithCanvas | True/False | 0/1 | Whether the caption is aligned with the canvas. Else, it will be aligned with the entire chart area |
captionHorizontalPadding | Number | In Pixels | If caption is not center aligned, lets you configure the padding (in pixels) from either edge. Will be ignored if caption is center aligned. |
Chart Cosmetics
The following attributes let you configure chart cosmetics like background color, background alpha etc.
Attribute | Type | Value | Description |
---|---|---|---|
showBorder | True/False | 0/1 | Whether to show a border around the chart or not. |
borderColor | Color | Hex Color Code | Border color of the chart. |
borderThickness | Number | In Pixels | Border thickness of the chart. |
borderAlpha | Number | 0 – 100 | Border alpha of the chart. |
bgColor | Color | Hex Color Code | This attribute sets the background color for the chart. You can set any hex color code as the value of this attribute. To specify a gradient as background color, separate the hex color codes of each color in the gradient using comma. Example: `#FF5904, #FFFFFF`. |
bgAlpha | Number | 0 – 100 | Sets the alpha (transparency) for the background. If you’ve opted for gradient background, you need to set a list of alpha(s) separated by comma. |
bgRatio | Number | 0 – 100 | If you’ve opted for a gradient background, this attribute lets you set the ratio of each color constituent. |
bgAngle | Number | 0-360 | Sets the angle of the background color, in case of a gradient. |
bgImage | Text | Any | To place any image (JPG/PNG/GIF) as background of the chart, enter the (path and) name of the background image as a URL without quotes around it. It should be in the same domain as the chart. |
bgImageAlpha | Number | 0 – 100 | This attribute specifies the opacity for the loaded background image. |
bgImageDisplayMode | Text | stretch, tile, fit, fill, center, none | Helps you specify the mode in which the background image is to be displayed. Stretch – expands the image to fit the entire chart area, without maintaining original image constraints. Tile – the image is repeated as a pattern on the entire chart area. Fit – fits the image proportionately on the chart area. Fill -proportionately fills the entire chart area with the image. Center – the image is positioned at the center of the chart area. None – Default mode. |
bgImageVAlign | Text | top, middle, bottom | Helps you to vertically align the background image. |
bgImageHAlign | Text | left, middle, right | Helps you to horizontally align the background image. |
bgImageScale | Number | 0-300 | Helps you magnify the background image.This attribute will only work when the attribute `bgImageDisplayMode` is set to none, center, or tile. |
showVLineLabelBorder | True/False | 0/1 | If you’ve opted to show a label for any of your vLines in the chart, you can collectively configure whether to show border for all such labels using this attribute. If you want to show label border for just a particular vLine, you can over-ride this value by specifying border configuration for that specific vLine. |
rotateVLineLabels | True/False | 0/1 | This attribute lets you set whether the vline labels will show up as rotated labels on the chart. Default value: 0 |
logoURL | Text | URL | You can load an external logo (JPEG/PNG) to your chart, this attribute lets you specify the URL. Due to cross domain security restrictions it is advised to use a logo from the same domain name as your charts. |
logoLeftMargin | Number | In Pixels | This attribute helps you set the amount of empty space that you want to put on the left side of your logo image. Nothing is rendered in this space. |
logoTopMargin | Number | In Pixels | This attribute helps you set the amount of empty space that you want to put on top of your logo image. Nothing is rendered in this space. |
logoPosition | Text | TL, TR, BL, BR, CC | Where to position the logo on the chart: TL – Top-left TR – Top-right BR – Bottom right BL – Bottom left CC – Center of screen |
logoAlpha | Number | 0 – 100 | Once the logo has loaded on the chart, you can configure its opacity using this attribute. |
logoScale | Number | 0-300 | You can also change the scale of an externally loaded logo at run-time by specifying a value for this parameter. |
logoLink | Text | URL | If you want to link the logo to an external URL, specify the link in this attribute. The link can be in Exago BI Link format, allowing you to link to new windows, pop-ups, frames etc. |
Data Plot Cosmetics
These attributes let you configure how your plot (columns, lines, area, pie or any data that you’re plotting) will appear on the chart. If the plots can show borders, you can control the border properties using the attributes listed below. Or, if they support gradient fills, you can again configure various properties of the gradient using these attributes. Various other controls over plot cosmetics can be attained using this set of attributes.
Attribute | Type | Value | Description |
---|---|---|---|
showPlotBorder | True/False | 0/1 | Whether the column, area, pie etc. border will show up. |
plotBorderColor | Color | Hex Color Code | Color for column, area, pie border |
plotBorderThickness | Number | 0-5 | Thickness for column, area, pie border |
plotBorderAlpha | Number | 0 – 100 | Alpha for column, area, pie border |
plotFillAlpha | Number | 0 – 100 | This attribute lets you set the fill alpha for plot. |
use3DLighting | True/False | 0/1 | Whether to use advanced gradients and shadow effects to create better looking 3D charts. |
Pie / Doughnut Properties
The following attributes let you control various functionality of pie/doughnut chart.
Attribute | Type | Value | Description |
---|---|---|---|
pieRadius | Number | In Pixels & Percentage | This attribute lets you explicitly set the outer radius of the chart. Exago BI automatically calculates the best fit pie radius for the chart. This attribute is useful if you want to enforce one of your own values. Starting v3.14.0, you can specify the radius of a doughnut chart in both percentage and pixel values. |
doughnutRadius | Number | In Pixels & Percentage | This attribute lets you explicitly set the inner radius of the chart. Exago BI automatically calculates the best fit radius for the chart. This attribute is useful if you want to enforce one of your own values. Starting v3.14.0, you can specify the radius of a doughnut chart in both percentage and pixel values. |
startingAngle | Number | 0-360 | By default, the doughnut chart starts from angle 0 degree that is, the first doughnut slice starts plotting from 0 degree angle. If you want to change the starting angle of the chart, use this attribute. It obeys the conventions of co-ordinate geometry where 0 degrees means hand of a clock at 3. Starting angle Increases anti-clockwise. |
enableSlicing | True/False | 0/1 | This attribute specifies whether slicing of the data plots should be enabled for pie/doughnut charts. Setting this attribute to `1` will enable slicing for the chart, setting it to `0` will disable slicing. Default value: 1 |
slicingDistance | Number | In Pixels | If you’ve opted to slice a particular pie/doughnut slice, using this attribute you can control the distance between the slice and the center of chart. |
enableRotation | True/False | 0/1 | The doughnut charts have three modes: Slicing, Rotation, and Link. By default, a chart starts in Slicing mode. If you need to enable rotation from XML, set this attribute to 1. But, when links are defined, the chart always works in Link mode irrespective of the value of this attribute. |
enableMultiSlicing | True/False | 0/1 | This attribute specifes whether single-slicing for the data plots should be enabled for pie/doughnut charts. Setting this attribute to `0` will enable single-slicing for the chart, setting it to `1` will enable multi-slicing. Default value: 1 |
pieYScale | Number | 30-80 | This attribute alters the y-perspective of the pie in percentage figures. 100 percent means the full pie face is visible and 0 percent means only the side face is visible. |
pieSliceDepth | Number | In Pixels | This attribute controls the pie 3D Depth. |
Smart Labels & Lines
In Exago BI, the pie and doughnut charts can now have smart labels and lines. Smart labels/lines are data connector lines which connect the pie/doughnut slices to their respective labels without over-lapping even in cases where there are lots of labels located near each other. You can configure the smart labels/lines properties using the attributes below.
Attribute | Type | Value | Description |
---|---|---|---|
enableSmartLabels | True/False | 0/1 | Whether to use smart labels or not. |
skipOverlapLabels | True/False | 0/1 | Whether to skip labels that are overlapping even when using smart labels. If not, they might overlap if there are too many labels. |
isSmartLineSlanted | True/False | 0/1 | The smart lines (smart label connector lines) can appear in two ways: Slanted or Straight. This attribute lets you choose between them. |
smartLineColor | Color | Hex Color Code | Color of smart label connector lines. |
smartLineThickness | Number | In Pixels | Thickness of smart label connector lines. |
smartLineAlpha | Number | 0 – 100 | Alpha of smart label connector lines. |
labelDistance | Number | In Pixels | This attribute helps you set the distance of the label/value text boxes from the pie/doughnut edge. |
manageLabelOverflow | True/False | 0/1 | This attribute tries to manage overflow of data labels. If enabled, data labels are either wrapped or truncated with ellipses to prevent them from overflowing out of the chart canvas. In case `smartLabels` is disabled, the labels are wrapped to avoid the overflow. Since `smartLabels` is disabled, the wrapped labels might get overlapped. When `smartLabels` is enabled, management of the overflowing labels fit in the “quadrant specific smart labeling algorithm”. Data labels try to wrap first. In case, there is a space constraint in the quadrant, the labels get truncated with ellipses. |
useEllipsesWhenOverflow | True/False | 0/1 | When enabled, long data labels are truncated by adding ellipses to prevent them from overflowing the chart background. The default value is 1. This setting works only when `manageLabelOverflow` is set to 1. |
Number Formatting
Exago BI offers you a lot of options to format your numbers on the chart. Using the attributes below, you can control a myriad of options like: Formatting of commas and decimals Number prefixes and suffixes Decimal places to which the numbers will round to Scaling of numbers based on a user defined scale Custom number input formats
Attribute | Type | Value | Description |
---|---|---|---|
formatNumber | True/False | 0/1 | This configuration determines whether the numbers displayed on the chart will be formatted using commas, for example, 40,000 if ‘formatNumber’: ‘1’; and 40000 if ‘formatNumber’: ‘0’;. |
formatNumberScale | True/False | 0/1 | Configuration whether to add K (thousands) and M (millions) to a number after truncating and rounding it – for example, if `formatNumberScale` is set to 1, 1043 will become 1.04K (with decimals set to 2 places). Same with numbers in millions – an M will be added at the end. |
defaultNumberScale | Text | Any | The default unit of the numbers that you’re providing to the chart. |
numberScaleUnit | Text | Any | Unit of each block of the scale. |
numberScaleValue | Text | Any | Range of the various blocks that constitute the scale. |
forceNumberScale | True/False | 0/1 | If a data value is less than the lowest given number is the number scale, this attribute forces the lower value of the `numberScaleUnit` to be applied to that data value. This attribute works only when `“formatNumberScale”: “1”` and the `defaultNumberScale` attribute is not defined. For example, if `“numberScaleUnit”: “K, M”`, `“numberScaleValue”: “1000, 1000”`, and `“forceNumberScale”: “1”`, a data value of `400` will be rendered as `0.40K`. |
scaleRecursively | True/False | 0/1 | Whether recursive scaling should be applied. |
maxScaleRecursion | Number | Any | How many recursions to complete during recursive scaling? -1 completes the entire set of recursion. |
scaleSeparator | Text | Any | What character to use to separate the scales that are generated after recursion? |
numberPrefix | Text | Character | Using this attribute, you could add prefix to all the numbers visible on the graph. For example, to represent all dollars figure on the chart, you could specify this attribute to $ to show like $40000, $50000. |
numberSuffix | Text | Character | Using this attribute, you could add a suffix to all the numbers visible on the graph. For example, to represent all figures quantified as per annum on the chart, you could specify this attribute to ‘/a’ to show like 40000/a, 50000/a. |
decimalSeparator | Text | Character | This attribute helps you specify the character to be used as the decimal separator in a number. |
thousandSeparator | Text | Character | This attribute helps you specify the character to be used as the thousands separator in a number. |
thousandSeparatorPosition | Number | This option helps you specify the position of the thousand separator. | |
inDecimalSeparator | Text | Character | In some countries, commas are used as decimal separators and dots as thousand separators. In XML, if you specify such values, it will give an error while converting to number. So, Exago BI accepts the input decimal and thousand separator from user, so that it can convert it accordingly into the required format. This attribute lets you input the decimal separator. |
inThousandSeparator | Text | Character | In some countries, commas are used as decimal separators and dots as thousand separators. In XML, if you specify such values, it will give an error while converting to number. So, Exago BI accepts the input decimal and thousand separator from user, so that it can convert it accordingly into the required format. This attribute lets you input the thousand separator. |
decimals | Number | 0-10 | Number of decimal places to which all numbers on the chart will be rounded to. |
forceDecimals | True/False | 0/1 | Whether to add 0 padding at the end of decimal numbers. For example, if you set decimals as 2 and a number is 23.4. If forceDecimals is set to 1, Exago BI will convert the number to 23.40 (note the extra 0 at the end). |
Font Properties
Using the attributes below, you can define the generic font properties for all the text on the chart. These attributes allow you a high level control over font properties. If you intend to specify font properties for individual chart elements (like Caption, sub-caption etc.), you’ll need to use the Styles feature of Exago BI. Using Styles, you can also specify advanced font properties like Bold, Italics, HTML Mode etc.
Attribute | Type | Value | Description |
---|---|---|---|
baseFont | Text | Font Name | This attribute lets you set the font face (family) of all the text (data labels, values etc.) on chart. |
baseFontSize | Number | 6 – 72 | This attribute sets the base font size of the chart that is, all the values and the names in the chart which lie on the canvas will be displayed using the font size provided here. |
baseFontColor | Color | Hex Color Code | This attribute sets the base font color of the chart that is, all the values and the names in the chart which lie on the canvas will be displayed using the font color provided here. |
Data Label Cosmetics
These attributes let you configure the cosmetics of all data labels of the chart.
Attribute | Type | Value | Description |
---|---|---|---|
labelFont | Text | Font Name | Sets the x-axis label font family for the text. |
labelFontColor | Color | Hex Color Code | Sets the x-axis label font color. |
labelFontSize | Number | 6 – 72 | Specifies the x-axis label font size. |
labelFontBold | True/False | 0/1 | Flag indicating whether x-axis label font should be bold or not. |
labelFontItalic | True/False | 0/1 | Flag indicating whether x-axis label font should be italicized or not. |
labelBgColor | Color | Hex Color Code | Sets the background color for x-axis label text. |
labelBorderColor | Color | Hex Color Code | Sets the color of the border around the x-axis label text. |
labelAlpha | Number | 0 – 100 | Sets the x-axis label alpha for both font and background. |
labelBgAlpha | Number | 0 – 100 | Sets the x-axis label background alpha. |
labelBorderAlpha | Number | 0 – 100 | Sets the x-axis label border alpha. |
labelBorderPadding | Number | In Pixels | Sets the x-axis label border padding. |
labelBorderRadius | Number | In Pixels | Sets the x-axis label border radius. |
labelBorderThickness | Number | In Pixels | Sets the x-axis label border thickness. |
labelBorderDashed | True/False | 0/1 | Whether the border around x-axis labels should be rendered using dashed lines.
Default value: 0 (border rendered using straight lines) |
labelBorderDashLen | Number | In pixels | Sets the length of each dash when the border around the x-axis labels are rendered using dashed lines. |
labelBorderDashGap | Number | In pixels | Sets the gap between two consecutive dashes when the border around x-axis labels are rendered using dashed lines. |
labelLink | URL | Any | Sets a link for every data plot labels. |
Legend Properties
In pie / doughnut charts, the name of each slice shows up in the legend of the chart. If you do not need the legend, you can opt to hide the same. Also, the legend can be placed at the bottom of the chart or to the right of the chart. Using the attributes below, you can configure the functional and cosmetic properties of the legend.
Attribute | Type | Value | Description |
---|---|---|---|
showLegend | True/False | 0/1 | Whether to show legend for the chart (only multi-series and combination charts). |
legendItemFontBold | True/False | 0/1 | Whether legend keys should be displayed in bold |
legendItemFont | Text | Font Name | Sets legend item font |
legendItemFontSize | Number | 6 – 72 | Sets legend item font size |
legendItemFontColor | Color | Hex Color Code | Sets legend item font color |
legendItemHoverFontColor | Color | Hex Color Code | Sets legend item font color on hover |
legendPosition | Text | bottom, right, top, top-left, top-right, bottom-left, bottom-right, left, left-top, left-bottom, right, right-top, right-bottom, and absolute | The legend can be plotted at different positions with respect to the chart. Note that if the value of `legendPosition` is set to `absolute`, you also need to set the coordinates of the legend. You can do that using the attributes `legendXPosition` and `legendYPosition`, both of which accept absolute or percentage values. |
legendXPosition | Number | 0 to chart width (in pixels) | When the value of `legendPosition` is set to `absolute`, use this attribute to set the X-coordinate of the legend. It accepts absolute or percentage values. By default, its value is set to `0`. |
legendYPosition | Number | 0 to chart height (in pixels) | When the value of `legendPosition` is set to `absolute`, use this attribute to set the Y-coordinate of the legend. It accepts absolute or percentage values. By default, its value is set to `0`. |
legendNumRows | Number | Any | Sets the number of rows the legend should display. |
legendNumColumns | Number | Any | Sets the number of columns the legend should display. |
legendCaptionAlignment | Text | “left”, “center”, “right” | Sets the legend caption horizontal alignment . |
legendCaptionFontBold | True/False | 0/1 | Whether legend caption should be displayed in bold |
legendCaptionFont | Text | Font Name | Sets legend caption font |
legendCaptionFontSize | Number | 6 – 72 | Sets legend caption font size |
legendCaptionFontColor | Color | Hex Color Code | Sets legend caption font color |
legendCaption | Text | You can add a caption for the entire legend by setting the same here. | |
legendItemHiddenColor | Color | Hex Color Code | Sets the color that applies on both text font and icon when they are in a disabled / hidden state |
legendIconScale | Number | 1-5 | Scaling of legend icon is possible in Exago BI. This attribute lets you control the size of the legend icon. The default scale value is 1. Anything less than 1 reduces the size of the legend-icons on the chart. Any value bigger than 1 enlarges the icons. for example, 0.5 means half the size, where as, 2 means twice the size. |
legendBgColor | Color | Hex Color Code | Background color for the legend. |
legendBgAlpha | Number | 0 – 100 | Background alpha for the legend. |
legendBorderColor | Color | Hex Color Code | Border Color for the legend. |
legendBorderThickness | Number | In Pixels | Border thickness for the legend. |
legendBorderAlpha | Number | 0 – 100 | Border alpha for the legend. |
legendShadow | True/False | 0/1 | Whether to show a shadow for legend. |
legendAllowDrag | True/False | 0/1 | The legend can be made drag-able by setting this attribute to 1. End viewers of the chart can drag the legend around on the chart. |
legendScrollBgColor | Color | Hex Color Code | If you’ve too many items on the legend, a scroll bar shows up on the same. This attribute lets you configure the background color of the scroll bar. |
reverseLegend | True/False | 0/1 | You can reverse the ordering of data sets in the legend by setting this attribute to 1. |
interactiveLegend | True/False | 0/1 | This attribute lets you interact with the legend in your chart. When you click a particular legend key, the associated slice slides out from the chart. Re-clicking the key causes the slice to slide in. |
legendNumColumns | Number | Zero and Positive Integers | The legend items are arranged in columns. Using this attribute, you can propose the number of columns. This value undergoes internal checking on judicious use of white-space. In case, the value is found improper, the chart auto-calculates the number of columns. When set to 0, the chart automatically decides the number of columns. The above is applicable when `legendPosition` is set to BOTTOM`.` If you have set RIGHT `legendPosition`, the number of columns is always set to 1. |
minimiseWrappingInLegend | True/False | 0/1 | Whether to minimize legend item text wrapping. |
drawCustomLegendIcon | True/False | 0/1 | Specifies whether drawing a custom legend icon will be enabled. All legend icon customization attributes will work only if this feature is enabled. Default value: 0 (disabled) |
legendIconBorderColor | Color | Hex Color Code | Sets the border color for the legend icon. Default value: Data plot border color |
legendIconBgColor | Color | Hex Color Code | Sets the background color for the legend icon. Default value: Data plot fill color |
legendIconAlpha | Number | 0 – 100 | Sets the legend icon transparency. Default value: 100 |
legendIconBgAlpha | Number | 0 – 100 | Sets the legend icon background transparency. Default value: 100 |
legendIconSides | Number | Any | Sets the number of sides for the legend icon. Default value: 4 |
legendIconBorderThickness | Number | 1-5 | Sets the thickness of the legend icon border. Default value: 1 |
legendIconStartAngle | Number | Any | Sets the starting angle of for drawing the legend icon. Default value: 45 |
alignLegendWithCanvas | True/False | 0/1 | This attribute if set to `0`, the legend box will be center aligned with respect to the entire width of the chart only if the total width of the legend box is more than the canvas width. By default, the legend box is center aligned with respect to the canvas width and it remains the same if the width of the legend box is less than the canvas width. |
Tool tip Attributes
These attributes let you control the tool tip. You can set the background color, border color, separator character and few other details.
Attribute | Type | Value | Description |
---|---|---|---|
showToolTip | True/False | 0/1 | Whether to show tool tip on chart. |
toolTipBgColor | Color | Hex Color Code | Background color for tool tip. |
toolTipColor | Color | Hex Color Code | Font color for the tool-tip. |
toolTipBorderColor | Color | Hex Color Code | Border color for tool tip. |
tooltipBorderAlpha | Number | 0 – 100 | Sets the border transparency for tool tip. |
toolTipSepChar | Text | Any | The character specified as the value of this attribute separates the name and value displayed in tool tip. |
showToolTipShadow | True/False | 0/1 | Whether to show shadow for tool-tips on the chart. |
tooltipbgalpha | Number | 0 – 100 | Sets the transparency of the tooltip. |
tooltipborderradius | Number | In Pixels | Sets the border radius of the tooltip. |
tooltipborderthickness | Number | In Pixels | Sets the border thickness of the tooltip. |
toolTipPadding | Number | In Pixels | This attribute sets the vertical space between the value and the border of the tooltip. If you want more space between the value and the border, you can use this attribute to control it. |
plottooltext | Text | Any | Specify custom text for the tooltip You can either specify a constant string as the tooltip text or you can use variable values from the data level by prefixing a `$` to the attribute name, for example, `$name`, `$value`. |
Toolbar Attributes
Using this set of attributes, you can customize the toolbar on the chart. The advantage of having a toolbar is that it manages all the UI action elements (context menus, checkboxes, buttons) centrally. This provides a clean, uniform look and a better, more meaningful and logical grouping.
Attribute | Type | Value | Description |
---|---|---|---|
toolbarPosition | Text | TL, TR, BL, BR, CC | Where to position the toolbar on the chart: TL – Top-left TR – Top-right BR – Bottom right BL – Bottom left CC – Center of screen |
toolbarX | Number | Any | Sets the toolbox position on the chart with respect to x-axis. |
toolbarY | Number | Any | Sets the toolbox position on the chart with respect to y-axis. |
toolbarHAlign | Text | Left, Right | Sets the horizontal alignment of the toolbar on the chart. |
toolbarVAlign | Text | Top, Bottom | Sets the vertical alignment of the toolbar on the chart |
toolbarButtonColor | Color | Any (color code without the # prefix) | Sets the color of the toolbar buttons. |
showToolBarButtonTooltext | True/False | 0/1 | Enables/disables display of tooltips for toolbar buttons. |
toolbarButtonScale | Number | Any | You can change the scale of the toolbar by specifying a value for this attribute. |
Attributes for Exporting Charts
These attributes allow you to control the saving of chart as image, SVG or XLSX.
Attribute | Type | Value | Description |
---|---|---|---|
exportEnabled | True/False | 0/1 | Whether the chart will allow exporting to images, PDFs, SVG, XLSX or CSV format.
Default value: 0 |
exportAction | Text | ‘save’ or ‘download’ | In case of server-side exporting, the action specifies whether the exported image will be sent back to client as download, or whether it’ll be saved on the server.
Default value: download |
exportHandler | Text | Any | In case of server side exporting, this refers to the path of the server-side export handler (the ready-to-use scripts that we provide). |
exportFormats | Text | Any | Lets you configure what output formats to allow for export of chart, in the export context menu, and also customize the label for each menu item. The attribute value should be a pipe (|) delimited separated key-value pair. Example: `exportFormats: ‘PNG=Export as High Quality Image|JPG|PDF=Export as PDF File’` |
exportMode | Text | Any | This attributes sets the modes of export. To enable client-side exporting, set this attribute to `client`.
Default value: auto. Note: Starting v3.12.1, the `exportMode` attribute replaces the `exportAtClientSide` attribute. However, you don’t need to make any changes to the existing setup because, the Exago BI library comes with the proper mapping already provided. |
exportShowMenuItem | True/False | 0/1 | Whether the menu items related to export (for example, Save as JPEG etc.) will appear in the context menu of chart. |
exportTargetWindow | Text | ‘_self’ or ‘_blank’ | In case of server-side exporting and when using download as action, this lefts you configure whether the return image, PDF, SVG or XLSX will open in same window (as an attachment for download), or whether it will open in a new window.
Default value: _self |
exportFileName | Text | Any | Using this attribute you can specify the name (excluding the extension) of the output (export) file. |
Data Plot Hover Effects
If you wish to show an effect on the data plot (column, line anchor, pie etc.) when the user hovers his mouse over the data plot, these attributes let you configure the cosmetics of the hover for all data plots in the chart.
Attribute | Type | Value | Description |
---|---|---|---|
showHoverEffect | True/False | 0/1 | Whether to enable hover effect on charts for all elements |
plotHoverEffect | True/False | 0/1 | Whether to enable hover effect on charts for data plots (for example, column, pie) only |
plotFillHoverColor | Color | Hex Color Code | Specifies the hover color for the data plots |
plotFillHoverAlpha | Number | 1 – 100 | Specifies the hover alpha for data plots |
plotBorderHoverColor | Color | Hex color code | This attribute sets the border color of the plot when hovered. |
plotBorderHoverAlpha | Number | 0 – 100 | This attribute sets the transparency of plot border when hovered. |
plotBorderHoverThickness | Number | In pixels | Sets the thickness of the border of plot when hovered. |
Chart Padding & Margins
The following attributes help you control chart margins and padding. Exago BI allows you to manually customize the padding of various elements on the chart to allow advanced manipulation and control over chart visualization. You can also define the chart margins. Chart Margins refer to the empty space left on the top, bottom, left and right of the chart. That means, Exago BI will not plot anything in that space. It’s not necessary for you to specify any padding/margin values. Exago BI automatically assumes the best values for the same, if you do not specify the same.
Attribute | Type | Value | Description |
---|---|---|---|
captionPadding | Number | In Pixels | This attribute lets you control the space (in pixels) between the sub-caption and top of the doughnut. If the sub-caption is not defined, it controls the space between caption and top of the doughnut. If neither caption, nor sub-caption is defined, this padding does not come into play. |
chartLeftMargin | Number | In Pixels | Amount of empty space that you want to put on the left side of your chart. Nothing is rendered in this space. |
chartRightMargin | Number | In Pixels | Amount of empty space that you want to put on the right side of your chart. Nothing is rendered in this space. |
chartTopMargin | Number | In Pixels | Amount of empty space that you want to put on the top of your chart. Nothing is rendered in this space. |
chartBottomMargin | Number | In Pixels | Amount of empty space that you want to put at the bottom of your chart. Nothing is rendered in this space. |
The data Object
In single-series charts, each instance of the `data` object represents a data value to be plotted on the chart. For a single-series chart, one instance of the `data` object looks as shown in the example below:
"data"[{
"label": "Jan",
"value": "10000"
}]
Attributes of the `data` object are used to set and configure the data values for the chart.
Attribute | Type | Value | Description |
---|---|---|---|
borderColor | Color | Hex Color Code | If you want to set border color of individual pie/doughnut data items, you can specify using this attribute. |
color | Color | Hex Color Code | If you want to define your own colors for the data items on chart, use this attribute to specify color for the data item. |
displayValue | Text | If instead of the numerical value of this data, you wish to display a custom string value, you can specify the same here. Examples are annotation for a data item etc. | |
isSliced | True/False | 0/1 | This attribute determines whether a pie slice appears as a part of the total chart or is sliced out as an individual item. |
label | Text | Any | This attribute determines the label for the data item. The label appears on the x-axis of chart.
Note: The `label` attribute replaces the `name` attribute. Previously, either one of the attributes could be used to set the label. Support for the `name` attribute has been discontinued since v3.10.0. |
link | Text | Any | You can define links for individual data items. That enables the end user to click on data items (columns, lines, bars etc.) and drill down to other pages. To define the link for data items, use the link attribute. You can define links that open in same window, new window, pop-up window or frames. Please see “Drill-Down > Using JavaScript Functions as Links” for more information. Also, you’ll need to Url Encode all the special characters (like ? and &) present in the link. |
showLabel | True/False | 0/1 | You can individually opt to show/hide labels of individual data items using this attribute. |
showValue | True/False | 0/1 | You can individually opt to show/hide values of individual data items using this attribute. |
toolText | Text | Any | By default, Exago BI shows the data item name and value as tool tip text for that data item. But, if you want to display more information for the data item as tool tip, you can use this attribute to specify the same. |
value | Number | Any | Numerical value for the data item. This value will be plotted on the chart. |
labelFont | Text | Font Name | Sets the x-axis label font family for the text. |
labelFontColor | Color | Hex Color Code | Sets the x-axis label font color. |
labelFontSize | Number | 6 – 72 | Specifies the x-axis label font size. |
labelFontBold | True/False | 0/1 | Flag indicating whether x-axis label font should be bold or not. |
labelFontItalic | True/False | 0/1 | Flag indicating whether x-axis label font should be italicized or not. |
labelBgColor | Color | Hex Color Code | Sets the background color for x-axis label text. |
labelBorderColor | Color | Hex Color Code | Sets the color of the border around the x-axis label text. |
labelAlpha | Number | 0 – 100 | Sets the x-axis label alpha for both font and background. |
labelBgAlpha | Number | 0 – 100 | Sets the x-axis label background alpha. |
labelBorderAlpha | Number | 0 – 100 | Sets the x-axis label border alpha. |
labelBorderPadding | Number | In Pixels | Sets the x-axis label border padding. |
labelBorderRadius | Number | In Pixels | Sets the x-axis label border radius. |
labelBorderThickness | Number | In Pixels | Sets the x-axis label border thickness. |
labelBorderDashed | True/False | 0/1 | Whether the border around x-axis labels should be rendered using dashed lines.
Default value: 0 (border rendered using straight lines) |
labelBorderDashLen | Number | In pixels | Sets the length of each dash when the border around the x-axis label is rendered using dashed lines. |
labelBorderDashGap | Number | In pixels | Sets the gap between two consecutive dashes when the border around x-axis label is rendered using dashed lines. |
labelLink | URL | Any | Sets the link for each individual data plot label. |
hoverColor | Color | Hex Color Code | This attribute can set the hover color for a particular data plot. |
hoverAlpha | Number | 0 – 100 | This attribute sets the transparency for a particular data plot when hovered. |
borderHoverColor | Color | Hex Color Code | This attribute sets the border color of the data plot on hover. |
borderHoverAlpha | Number | 0 – 100 | This attribute sets the border’s transparency for the data plot on hover. |
borderHoverThickness | Number | In pixels | This attribute sets the thickness for the data plot’s border on hover. |