Advanced Multi Chart Widget
This widget belongs to the Dashboards category in the widget library. It is used to combine several types of charts and to add a secondary measure axis in order to improve readability. The data can be as follows:
- Different.
Number of incidents vs Time spent by the Service Desk - Be related to different measure scales. Number of incidents per working day vs Number of incidents per weekend
You can use numerous properties to format the chart, e.g. display and format the chart title and axes, define the position of the legend, use the color palette, format axis labels, display tooltips, etc.
Examples
CSV file data
- Dimension = 6 weeks
- 2 measures = Number of incidents and Time spent by the Service Desk
Note: The data source contains several measures. You select the measures you want (working days in the week and time spent in hours) using the Data Transformer.
Download
Chart 1:
- Number of incidents per working day ==> Stacked column chart - measure axis on the left
- Number of incidents per weekend ==> Spline chart - measure axis on the right
Chart 2:
- Number of incidents per working day ==> Stacked column chart - measure axis on the left
- Time spent by the Service Desk ==> Area chart - measure axis on the right
| Number of incidents over the week vs Number of incidents over the weekend | Number of incidents over the week vs Time spent by the Service Desk |
|---|---|
 |
 |
Notes
- The types of charts available are defined by
. You cannot add to them. - The primary measure axis is always displayed on the left and the secondary axis always on the right.
- Each type of chart refers to one of the measure axes.
- For column charts and other similar charts, measures can be stacked (aggregated values) or clustered (individual values).
- The scale of each measure axis (primary and secondary) can be defined manually. By default, it starts at 0 and continues up to the maximum value of the selected measures.
- The legend can be used as a dynamic data filter in execute mode. To use it, click the label.
Best practice
- You should use this widget when you want to combine elements from a given dimension that have different ranges of values in a single chart.
- To display a time series, you should use the Line Chart or Spline Chart widget.
- If you want to highlight the distribution of values instead of the total value, you should use stacked columns or bars. The total of each element is equal to 100%. The values within each element represent percentages.
- Select the measures you want using the Data Transformer. If you do not do so, they will all be included.
Note: If your data source contains numerous measures and dimensions, your chart will be difficult to read. If this is the case, you should only select the most important measures. - To improve the readability of different ranges within the measure axes, you can increase the height of the widget.
List of properties
Content
DataSource
Data Source: External data source associated with the widget.
- The drop-down list displays all of the data sources available in the app.
- To modify the data source or to view its contents, you should click
. The 
button below the Preview property shows the number of rows (max. 15) and columns extracted. - To define a new data source, click
Add Data Source in the Objects pane.
DataTransformer
Data Transformer: Used to define the structure and scope of the data source, apply statistical aggregate functions and modify the order of the measures displayed.
- Click Setup / Preview Data below the Data Transformer property to open the dedicated window.
See the description.
EnableDrilldown
Enable Drilldown (Note: Only for an EasyVista data source data source using a view with grouping levels): Used to indicate if data is aggregated (box is checked - the drill-down functionality is enabled) or not (box is not checked).
example Breadcrumbs widget: Breakdown of equipment by location.
- If you want the widget to display the breakdown in a grouping level, you should not check this box.
- Add a Breadcrumb widget to facilitate navigation within grouping levels.
Data
SortByValueDescending
Sort By Value Descending: Used to sort dimension elements in descending order (if the box is checked, from highest to lowest value) or in the order in which they are read in the data source (box is not checked). Note: The order applied is determined by the dimension elements of the first measure in the data source.
Click to see an example: Charts for incidents and requests per employee
The data source contains the Department dimension with three elements. 
| Box is checked | Box is not checked |
|---|---|
|
The dimension elements of each measure are sorted in descending order. |
The dimension elements of each measure are displayed according to the sort order of the data source. |
FirstRowContainsDimensionElements
First Row Contains Dimension Elements: Used to specify the structure of the data source by indicating if dimension elements are found in the first column (box is not checked: standard data source structure) or in the first row (box is checked). Note: This property does not affect the behavior of the Data Transformer.
MaximumNumberOfData
Maximum Number Of Data: Used to indicate the maximum number of dimension elements to be loaded from the data source for each measure selected in the data source.
You should use this property to prevent loss of performance when data volume is large.
- The count is always performed from the first dimension element.
- When the number of dimension elements to be loaded is greater than the number of dimension elements in the data source, all of the data is loaded.
- To view the data source, click next to the Data source property, then click button below the Preview property which shows the number of measures and the number of dimension elements for each measure.
Click to see an example: Charts for incidents and requests per employee
The data source contains the Department dimension with three elements.
Maximum Number Of Data = 20 (default value)
Maximum Number Of Displayed Data = 20 (default value) |
Maximum Number Of Data = 2
Maximum Number Of Displayed Data = 20 (default value) |
Maximum Number Of Data = 20 (default value)
Maximum Number Of Displayed Data = 1 |
|---|---|---|
|
All dimension elements are loaded and displayed for each measure, i.e. the three departments. |
Only the first two dimension elements are loaded and displayed for each measure, i.e. the first two departments. |
All dimension elements are loaded but only the first element is displayed. This corresponds to the Sales department. The Others dimension element groups values from the Marketing and Administration departments. |
MaximumNumberOfDisplayedData
Maximum Number Of Displayed Data: Used to indicate the maximum number of dimension elements to be displayed for each measure selected in the data source. This improves chart readability.
example You want to display the chart for incidents and requests per employee. See the Maximum Number Of Data field.
- The count is always performed from the first dimension element.
- When the number of dimension elements to be displayed is less than the number of dimension elements to be loaded, the Others dimension element will automatically be added to the chart. It will aggregate all of the values from non-displayed dimension elements.
Data Series
List of chart types to be displayed. Each of them displays one dimension element related to a measure axis. See the examples.
- Click Add Series to add a chart type and specify the three properties below.
- Click
to delete a chart type.
Y Axis Position: Position of the measure axis for showing data from the selected chart type.
- Left: Primary axis displayed to the left of the chart.
- Right: Secondary axis displayed to the right of the chart.
Chart Type: Type of chart.
- Area: Area chart. See the Advanced Area Chart widget.
- Column: Vertical column chart. See the Advanced Column Chart widget.
- Line: Line chart. See the Advanced Line Chart widget.
- Spline: Spline chart. See the Advanced Spline Chart widget.
Column : Element to be displayed for the selected chart type. Note: Only the measures selected via the Data Transformer will be available.
Charts
AdvancedDashboards_Charts_StackedView
Stacked View: Used to indicate if the measure values of each dimension element should be stacked one on top of the other (box is checked) or not (box is not checked). If you want them to be stacked, you should specify the display in the Stacked Mode list.
Stacked Mode: Display of stacked values.
- Normal: Measures are displayed in raw values.
- The maximum value of the scale is equal to the highest total value of measures for dimension elements.
- Percent: Measures are displayed in percentages based on the total value of the dimension element.
- The scale will range from 0 to 100.
- All bars will have the same maximum height of 100.
| Individual values (box is not checked) | Stacked values (box is checked) | |
|---|---|---|
| Raw values
(Stacked Mode = Normal) |
Total values = 100%
(Stacked Mode = Percent) |
|
 |
 |
 |
X Axis
AdvancedDashboards_XAxis
Axis Position: Position of the dimension axis. Note: The name of the axis is also affected by the position.
- Top: The axis is placed at the top of the chart and the name appears above the axis.
- Bottom: The axis is placed at the bottom of the chart and the name appears below the axis.
| Name above the axis (Top option) | Name below the axis (Bottom option) |
|---|---|
 |
 |
Axis Color (Inherit): Color of the dimension axis.
Tickmarks Color (Inherit): Color of tickmarks in the dimension axis.
Display Axis Name: Used to indicate if the name of the dimension axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.
- The name appears above or below the chart depending on the value specified in Axis Position.
| Axis name displayed above the chart (box is checked and Axis Position = Top) | Axis name displayed below the chart (box is checked and Axis Position = Bottom) |
|---|---|
 |
 |
Display format of the axis name: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font |  |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
X Axis Label
AdvancedDashboards_XAxisLabel
Display Axis Label: Used to indicate if the measure axis labels should be displayed (box is checked) or not (box is not checked). The labels are from the data source.
- Define the display format using the properties below.
Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single row. To display all labels over two rows, you can stagger them by checking this option.
| Display in one row (box is not checked) | Staggered display over two rows (box is checked) |
|---|---|
|
Note: To display all labels in a single row, you can also:
|
Label Length (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be truncated (box is checked) or not (box is not checked). If you want to truncate them, you should enter the number of characters for each label in Truncate Value.
| Truncated labels (box is checked and Truncate value = 4) | Non-truncated labels (box is not checked) |
|---|---|
 |
Note: The Is Rotate property is enabled. |
Is Rotate (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).
- A negative value rotates text to the right.
- A positive value rotates text to the left.
- When the value is zero, labels are not rotated.
Display format of the dimension axis labels, e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
X Lines
AdvancedDashboards_XLines
Display Lines: Used to indicate if horizontal gridlines should be displayed (box is checked) or not (box is not checked). These horizontal gridlines are parallel to the dimension axis.
- Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
- You can modify the color of gridlines in Color.
Y Axis
Left Axis
AdvancedDashboards_YLeftAxis
Min Value: Minimum start value of the scale of the measure axis.
- By default, the scale will start with the lowest value in the data source, rounded down to the nearest tenth.
22 ==> 20
Max Value: Maximum end value of the scale of the measure axis.
- By default, the scale will end with the highest value in the data source, rounded up to the nearest tenth.
42 ==> 50
| Default values | Values specified manually (min = 27; max = 45) |
|---|---|
 |
 |
Axis Color (Inherit): Color of the measure axis.
Tickmarks Color (Inherit): Color of tickmarks in the measure axis.
Display Axis Name: Used to indicate if the name of the measure axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.
- The name appears to the left or right of the chart depending on the value specified in Axis Position.
| Axis name displayed left of the chart (box is checked and Axis Position = Left) | Axis name displayed right of the chart (box is checked and Axis Position = Right) |
|---|---|
 |
 |
Display format of the axis name: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
AdvancedDashboards_YLeftAxis_DataType
Data Type: Used to define the display format of values in the measure axis and in tooltips (Common > Tooltip section). Note: The number format, e.g. comma or period for the decimal symbol, depends on the configuration settings of the platform used by the logged-in user. In Windows, this is specified in the Control Panel > Regional and Language Options.
- Integer: Whole numbers rounded up or down to the nearest unit.
152200.87 ==> 152201
- Float: Values with 2 decimals
152200.87 ==> 152200.87
Left Axis Label
AdvancedDashboards_YLeftAxisLabel
Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single column. To display all labels over two columns, you can stagger them by checking this option.
| Display in one column (box is not checked) | Staggered display over two columns (box is checked) |
|---|---|
 |
Note: To display all labels in a single column, you can rotate them using the Is Rotate property. |
Is Rotate: Used to indicate if the measure axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).
- A negative value rotates text to the bottom.
- A positive value rotates text to the top.
- When the value is zero, labels are not rotated.
Prefix: Alphanumeric value added to the start of each label in the measure axis.
Labels preceded by the measure unit
- Prefix = M
- Label = 150
==> value displayed: M 150
Suffix: Alphanumeric value added to the end of each label in the measure axis.
Labels ended with the measure unit
- Suffix = K
- Label = 150
==> value displayed: 150 K
Display format of the primary measure axis labels, e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
Right Axis
Display Right Axis: Used to indicate if the secondary measure axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should specify its properties.
- The secondary measure axis is always displayed to the right of the chart.
- Check the Display Axis Name box and enter a title.
Min Value: Minimum start value of the scale of the secondary measure axis.
- By default, the scale will start with the lowest value in the data source, rounded down to the nearest tenth.
22 ==> 20
Max Value: Maximum end value of the scale of the secondary measure axis.
- By default, the scale will end with the highest value in the data source, rounded up to the nearest tenth.
42 ==> 50
| Default values | Values specified manually (min = 15; max = 33) |
|---|---|
 |
 |
Axis Color (Inherit): Color of the secondary measure axis.
Tickmarks Color (Inherit): Color of tickmarks in the secondary measure axis.
Display Axis Name: Used to indicate if the title of the secondary measure axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.
- The title is always displayed to the right of the axis.
Display format of the secondary measure axis, e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
Right Axis Label
Properties specific to the secondary measure axis (Note: Only if the Display Right Axis box is checked).
AdvancedDashboards_YLeftAxisLabel
Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single column. To display all labels over two columns, you can stagger them by checking this option.
| Display in one column (box is not checked) | Staggered display over two columns (box is checked) |
|---|---|
|
Note: To display all labels in a single column, you can rotate them using the Is Rotate property. |
Is Rotate: Used to indicate if the measure axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).
- A negative value rotates text to the bottom.
- A positive value rotates text to the top.
- When the value is zero, labels are not rotated.
Prefix: Alphanumeric value added to the start of each label in the measure axis.
Labels preceded by the measure unit
- Prefix = M
- Label = 150
==> value displayed: M 150
Suffix: Alphanumeric value added to the end of each label in the measure axis.
Labels ended with the measure unit
- Suffix = K
- Label = 150
==> value displayed: 150 K
Y Lines
AdvancedDashboards_YDisplayLines
Display Lines: Used to indicate if vertical gridlines should be displayed (box is checked) or not (box is not checked). These vertical gridlines are parallel to the measure axis.
- Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
- You can modify the color of gridlines in Color.
Common
AdvancedDashboards_Common_General
Animation: In execute mode, this is used to indicate if the chart should be displayed in dynamic mode (box is checked) or in static mode (box is not checked). In dynamic mode, elements are displayed one after the other while in static mode, they are displayed at the same time.
AdvancedDashboards_Common_DisplayPrintExportButton
Display Print and Export Button: Used to indicate if users can save and print the chart (box is checked) or not (box is not checked). If users can save and print it, the 
and 
icons will appear. Note: The icons are always displayed to the right of the chart.
- : Used to save the chart in a JPG file.
- : Used to print or save the chart in a PDF file.
AdvancedDashboards_Common_DisplayAreaColor
Display Area Color: Used to indicate if a specific color should be applied to the background (box is checked) or not (box is not checked). If you want a background color, you should select it in Chart Area Color.
- The area of the background is delimited by the dimension axis and the measure axis.
- To apply a background color to the entire chart, use the Theme > Background Color property. The background color defined in the Display Area Color property will have priority.
| Background color defined (box is checked) | White background (box is not checked) | Background color for the entire chart (Theme property) |
|---|---|---|
 |
 |
 |
Title
AdvancedDashboards_Common_DisplayChartTitle
Display Chart Title: Used to indicate if a title should be added to the chart (box is checked) or not (box is not checked). If you want to add a title, you should enter it in Chart Title and define its format.
Display format of the chart title: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
Labels Points on the Graph
AdvancedDashboards_Common_DisplayPointLabel
AdvancedDashboards_Common_DisplayPointLabel_WithoutPosition
Display Point Label: Used to indicate if data labels in the chart should be displayed (box is checked) or not (box is not checked). If you want to display data labels, select the information to be displayed from the Label list.
- By default: Value of the dimension axis followed by the value of the measure axis.
- Define the display format, e.g. font, background color, text color, etc.
Label (Note: Only if the Display Point Label box is checked): Information displayed in the chart.
- Name: Values of the dimension axis.
- Value: Values of the measure axis.
- Click x to return to the default option where the two values are displayed.
| Default display | Values of the dimension axis
(Name option) |
Values of the measure axis
(Value option) |
|---|---|---|
 |
 |
 |
Display format of the data labels: e.g. font, background color, text color, etc.
PageGeneralFormat
| Font Family (Inherit) | Font of the text, selected via Select Font | |
|
| Size | Font size, selected via the slide or specified directly in the field | ||
| Alignment (Inherit) | Alignment of the text (Left/Center/Right/Justified) | ||
| Style (Inherit) | Font style of the text Bold/Italic/Underline) | ||
| Background Color (Inherit) | Background color of the widget | ||
| Text Color (Inherit) | Color of the text displayed by the widget
Note: Priority is given to the font and color defined using the text editor |
AdvancedDashboards_Common_DisplayPointLabel_WithoutPositionEnd
Position: Position of data labels in the chart.
- Inside the Chart: Within the chart.
- Outside the Chart: Outside the chart. You should use this option when information tends to overlap within the chart. This will provide more space for longer data labels.
| Within the chart (Inside option) | Outside the chart (Outside option) |
|---|---|
 |
 |
Color Palette
AdvancedDashboards_Common_ColorPalette
Chart Color: Color palette applied to the chart. This is used to define the color of chart data and the color of legend buttons.
- The list is provided by .
- The number of colors in the palette is indicated next to its name, e.g. Brown (6), Default (12), EasyVista (7).
- The color of other chart elements, e.g. axis title and labels, chart title and tickmarks, are defined using specific properties.
Legend
AdvancedDashboards_CommonLegend
AdvancedDashboards_CommonLegend_DisplayTitle
Display Legend: Used to indicate if the chart legend should be displayed (box is checked) or not (box is not checked).
- Each legend is made up of the name of the dimension element preceded by a button.
- The color of the buttons is defined by the color palette applied to the chart (Common > Color Palette property).
- Define the position of the legend using the Layout, Position, Horizontal and Vertical properties. Caution: Depending on the selected options, the chart will automatically be resized to allow legends to be fully displayed.
- Note: The legend can be used as a dynamic data filter in execute mode. When you click a button or name, you can display or hide the corresponding values in the chart.
Display Legend Title (Note: Only if the Display Legend box is checked): Used to indicate if a title should be added above the chart legend (box is checked) or not (box is not checked).
AdvancedDashboards_CommonLegend_DisplayTitleEnd
Layout (Note: Only if the Display Legend box is checked): Orientation of the chart legend.
- Horizontal: Legend labels are displayed horizontally, adjacent to each other.
- Vertical: Legend labels are displayed vertically, one below the other.
| Legend in rows (Horizontal option) | Legend in columns (Vertical option) |
|---|---|
 |
 |
Properties for the legend position (Note: Only if the Display Legend box is checked).
Click to see the summarized layouts.
- Vertical alignment (Layout = Vertical)
- Horizontal alignment (Layout = Horizontal)
Position: Position of the legend within the chart.
- Top: At the top of the chart.
- Bottom: At the bottom of the chart.
- Left: To the left of the chart.
- Right: To the right of the chart.
Horizontal Align (Note: Only if Position = Top or Bottom): Horizontal position of the chart legend.
- Left: To the left of the chart.
- Center: In the center of the chart.
- Right: To the right of the chart.
Vertical Align (Note: Only if Position = Left or Right): Vertical position of the chart legend.
- Top: At the top of the chart.
- Center: At the top of the chart.
- Bottom: At the bottom of the chart.
Tooltip
AdvancedDashboards_CommonTooltip
Display Tooltip: Used to indicate if data labels should be displayed in a tooltip when the cursor hovers over the chart (box is checked) or not (box is not checked). If you want to display tooltips, select the information to be displayed from the Label list.
- Information displayed by default when the cursor hovers over each data point: Value of the dimension axis / Value of the measure axis
- Define the display format using the properties below.
Tooltip Display Mode (Note: Only if the Display Tooltip box is checked): Used to define the information displayed when the cursor hovers each data point.
- Single: Value of the dimension axis / Value of the measure axis
- Union: Value of the dimension axis / All values of the measure axis
| Current value of the measure axis (Single option) | All values of the measure axis (Union option) |
|---|---|
 |
 |
Position (Note: Only if the Display Tooltip box is checked): Position of the data point's tooltip based on the movement of the cursor.
- Float: The tooltip will move along with the cursor.
- Point: The tooltip always appears above the data point regardless of the position of the cursor.
Theme
See the description of properties.