Configuring Bar Chart Elements¶
"Bar chart elements" can be used to visually represent the distribution and relationships among data categories. They also facilitate comparisons of values across different categories or groups. Following configuration sections are specific for "Bar Chart Elements".
Bar Chart Element Configuration Dashboard Preview¶
Data¶
Connect and configure a data source created by using "DataSource Designer"
Configuration Properties¶
Note: You can navigate to the selected data source by clicking the navigation button (
)
| Property | Description |
|---|---|
| Data Source | Select an available data source from the "Datasource" drop down menu |
| X Axis | Select a column from the "DataSource"to be mapped with the X-Axis of the bar chart |
| Y Axis | Select a column from the "DataSource"to be mapped with the Y-Axis of the bar chart |
| Aggregate | Select the aggregation type for the Y- Axis from the "Aggregate" dropdown menu |
| Transpose Data | Switch the values of "Rows" and "Columns" of the data source, apply the same aggregation type to the Y-Axis and re-draw the bar chart |
| Use Multi series | Select this option to display multiple sets of data side by side within the same "Bar Chart Element". |
| Series Based On Column(s) | (Only available when you select "Use Multi Series" option) Each data series consists of a bar representing different columns in the data source. Select a column and aggregation type for each series. (More Info.) |
| Series Based On Values in a Column | (Only available when you select "Use Multi Series" option ) Devide main data series selected for the "X - Axis" in a bar chart element to multiple series. (More Info.) |
| Split Series Column | (Only available when you select "Series Based On Values in a Column" option) (More Info.) |
Series Based on Column(s)¶
Note:
- Add an additional column by clicking the "+" Icon (
) appear after selecting the "Series Based on Column" option. - Select a column from the data source using the "Column" drop-down menu.
- Select an appropriate aggregation type from "Aggregate" drop-down menu.
Series Based on Values in a Column¶
Example:The provided example illustrates a data table representing orders dispatched from three distinct companies (Company 1, 2, 3) to four different sites (Site 1, 2, 3, 4). In a typical scenario, when you establish the linkage between the data source and its corresponding columns, a bar chart will be generated automatically, as demonstrated in the first section of the diagram.
If you select Series Based On Values in a Column, system will prompt you with an option to add an additional column to split the main bar chart series.
Example: In this scenario, the user selects the site column from the Split Series Column dropdown menu. Subsequently, the system autonomously divides the primary series based on the secondary series chosen by the user.
Split Series Column¶
Note:
- Select a column from the data source that can be used to split the 'X-Axis data column.
- The same aggregation type applied to the 'X-Axis' will also be applied to this new column.
Formatting¶
Add additional formatting to the aggregated data from the "Formatting" section.
Configuration Properties¶
| Property | Description |
|---|---|
| Use Top N option | Select this option to display only the top most categories within the "Bar Chart Element" for increased clarity. Note: This option gets neglected when you select "Use Multi series" option from the "Data" section. |
| Mode | (Only available after selecting the "Use Top N option" ) Select the method of considering the highest proportions to be visualized within the element, from the "Mode" dropdown menu for the "Use Top N Options" condition. Available Modes: Count Threshold percent Threshold value. |
| Show others | (Only available after selecting the "Use Top N option" ) Select this option to combine values from all the excluded categories into a single group labeled as "Other," which will be displayed as a separate category within the "Bar Chart Element." |
| Count/Threshold percent/Threshold value | (Only available after selecting the "Use Top N option" ) Enter a threshold value for data inclusion, system will automatically group rest of the values falling below this threshold to a separate bar and display it as "Other". |
| Orientation | Change the orientation of the bar chart (Vertical or Horizontal) |
| X Axis Title | Title for the X-Axis |
| Y Axis Title | Title for the Y-Axis |
Navigation¶
Configuration Properties¶
| Property | Description |
|---|---|
| Add additional Columns Related To Navigation | Add additional columns that will be used in the navigation (More Info.) |
| Use Datasource Condition | (More Info.) |
| Ignore Data Types During URL Parameterization | (More Info.) |
| URL Address | (More Info.) |
Add additional Columns Related To Navigation¶
If you have extra fields declared in the "URL Address" section that won't be used within the element, utilize this option to declare each of those fields in the "Navigation" section, so it can be used with the navigation URL.
Note: Add an additional columns related to navigation by clicking the "+" Icon () in the "Navigation" section.