Bullet Chart Widget
This type of widget belongs to the Dashboards category in the widget library. It enables you to compare, for a given dimension element, an observed value with the reference value, e.g. target or objective to be attained, value of the previous period, etc. The comparative analysis is performed using a horizontal bar chart. The observed value and the reference value
are placed on a quantitative scale with thresholds that display different segments graphically using shades of gray.
Notes
see General remarks on widgets
- The data source must contain one Dimension column, an optional Dimension sub-title column and two Measure: Observed value and Target value columns.
- Different dimension elements can be processed simultaneously, e.g. the number of incidents solved and the number of closed requests.
- The legend of the chart corresponds to the dimension element followed by the dimension sub-title.
- At least one threshold must be specified for the chart.
- Thresholds are common to all dimension elements.
- Values in the quantitative scale are automatically calculated from 0 up to the maximum value of the observed/reference values, increased by 10%. They cannot be modified. To improve the readability of different ranges between these two limits, you can increase the width of the widget.
- In execute mode, infotips appear when you move the mouse over each element of the chart.
Best Practice
- You should use the Bullet Chart widget to compare a value with a target value.
- To highlight a value as compared with thresholds that display different segments graphically using customizable colors, you should use the Gauge widget.
Example
You want to compare the number of incidents currently solved (observed value measure) with the target number of incidents to be solved (reference value measure) for the number of incidents solved (dimension element). The quantitative scale contains 3 thresholds: 100; 350; 500.
Data source | Bullet Chart widget |
---|---|
|
![]() |
List of properties
Content
First / Second / Third Landing: Used to identify the quantitative thresholds placed on the scale. Each new threshold will be displayed in a different shade of gray. Note: At least one threshold must be specified for the chart.
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.
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.
- 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.