Bar Chart Widget
This type of widget belongs to the Dashboard category in the widget library. It enables you to view, for a given measure, dimension element values using bars whose height is proportionate to the quantity represented.
Notes
See General information on widgets
- As a general rule, a data source contains one Dimension column and one or more Measure columns.
- Different measures that are related to the same dimension elements can be processed simultaneously, e.g. Number of incidents and Number of requests for the 3 departments, Sales, Marketing and Administration.
- Select the measures you want using the Data Transformer. If you do not do so, all of the measures will automatically be processed.
- Each measure is represented by a bar placed in the same chart.
- In execute mode, the legend displayed at the top right of the chart is a dynamic data filter (Chart Label -/- Legend > Legend). Infotips appear when you move the mouse over each segment.
- Measure axis values can start from 0 or from the minimum value of the measures selected. They end with the maximum value of the measures selected. To improve the readability of different ranges between these two limits, you can increase the height of the widget.
- You can use a horizontal bar chart or a vertical column chart.
- Bars can be stacked (aggregated values) or clustered (individual values).
Best practice
- Use the Bar Chart widget when dimension elements contain data that you want to compare.
- If dimension elements contain a chronological series, e.g. 12 consecutive months, you should use the Line Chart widget to display the trend over this period of time or to compare trends for different measures.
- To view the quantity of each element or to highlight one element as compared with the whole, you can use the Pie or Donut Chart widget.
Example
You want to view the number of incidents (measure) per year (dimension with 3 elements: Sales, Marketing and Administration). Data will be displayed in the format for large numbers (1k = 1000).
| Data source | Bar Chart widget |
|---|---|
|
Note: The data source contains several measures. You select the measure you want (number of incidents per employee) using the Data Transformer.
|
 |
Download 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
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.
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. |
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.
Chart
ColorTheme
Color Theme: Color theme applied to the chart. This affects the color of Bar Chart widgets, Line Chart widgets and Pie/Donut Chart widgets as well as the color of the buttons for each legend.
- The list is provided by EasyVista.
- The number of theme colors is indicated next to the theme name, e.g. Brown (6), Default (12), EasyVista (7).
MeasureAxisDataType
Measure Axis Data Type: Used to define the display of values in the axis and infotips. 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: Used to display whole numbers rounded up or down to the nearest unit.
example 152200.10 ==> 152200
- Float: Used to display values with 2 decimal places.
example 152200 ==> 152200.00
- Big Number: Used to display values converted to thousands (k), millions (m), billions (G) followed by the unit symbol. Numbers are rounded up or down to the nearest unit.
example 152200 ==> 152k
Chart Orientation: Used to present the chart with horizontal bars or vertical columns.
| Horizontal option | Vertical option |
|---|---|
 |
 |
Chart Type: Display mode for dimension element values.
- Normalized Stacked Bar: The values of each dimension element for a given measure are stacked one on top of the other. This display mode enables you to compare aggregated values for different measures visually, e.g. the total number of incidents vs. the total number of requests.
- Grouped Bar Chart: The values of each dimension element for a given measure are displayed side by side. This display mode enables you to compare values of different dimension elements for each measure, e.g. the number of incidents by department, the number of requests by department.
| Normalized Stacked Bar option | Grouped Bar Chart option |
|---|---|
 |
 |
Animation: In execute mode, used to indicate if bars are displayed one after the other (box is checked: dynamic mode) or if all bars are displayed at the same time (box is not checked: static mode).
Chart Label -/- Legend
ChartLabelLegendBarLineChart
Properties of the legends.
| Property | Description | Representation | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Element | Object to format |  |
||||||||||||||||||||
| (1) | Axis: Values of the axis | |||||||||||||||||||||
| (2) | Axis Legend: Legend of the axis | |||||||||||||||||||||
| (3) | Legend: Legend displayed at the top right of the chart | |||||||||||||||||||||
Graphic properties of the selected object
PageGeneralFormat
|
||||||||||||||||||||||
RotateDimensionAxisLabel
Rotate Dimension Axis Label: Used to indicate if the dimension axis labels are rotated (box is checked) according to the angle defined in Rotate value or if they are displayed horizontally (box is not checked).
RotateValue
Rotate Value (Note: Only when the Rotate Dimension Axis Label box is checked): Value defining the direction of dimension axis labels.
- A negative value rotates text to the right.
- A positive value rotates text to the left.
- When the value is zero, the labels are not rotated.
BottomMargin
Bottom Margin (Note: Only when the Rotate Dimension Axis Label box is checked): Value of the margin between the bottom of the chart and the bottom of the widget border. This defines the space available for displaying the dimension axis labels.
Legend
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.
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.
DisplayDimensionAxisLabel
Display Dimension Axis Label: Used to indicate if a title should be displayed below the dimension axis (box is checked) or not (box is not checked). To display the title, enter the title in Dimension Axis Label.
DisplayMeasureAxisLabel
Display Measure Axis Label: Used to indicate if a title should be displayed to the left of the measure axis (box is checked) or not (box is not checked). To display the title, enter the title in Measure Axis Label.