The bar chart - one of the most common chart types - can be used in a variety of analyses to visualise data in a simple and yet highly effective way. Therefore, in Exply, the bar chart is one of the most powerful chart types with a wide range of data and display options.
Every widget comes with a different set of options. All available options are described in the following passage.
Bar and Row Charts are very versatile in displaying a wide variety of data and visualisations. Here is what you need to know.
Filters are a very powerful way to narrow your visualisations down to a specific focus.
Part of the whole filter feature is the possibility to add filters at value-level within widgets.
You can add calculations to your value fields. To find out more about how to implement them, check out the Calculations section.
Stacking & Pivot
The Stacking Field option allows you to pivot your data by a second dimension. Here is an example:
Adding the city-category as a Stacking Field pivots the data by city and creates stacked bars:
Display options are used to modify the appearance of a widget. The following options are available:
Leading Primary Value
By enabling he Leading Primary Value option the Bar Chart will only show secondary values where the primary value has data.
For example, you want to compare the Tempo Workload Hours of certain team members with the sum of estimates of the issues they are assigned to. The 1st Value Field would be Workload Hours of Team Members of a certain team and the 2nd Value Field would be Original Estimate - with the new option only the filtered team members will be populated with the estimated hours as a second value.
By default this option is deactivated.
Enabling this option will show the selected category stacking field as separate bars, instead of stacked bars.
By default this option is deactivated.
Per default values are sorted by value in descending order. The following sorting options are available:
- Value descending
- Value ascending
- Name descending
- Name ascending
Max Number of Bars
... defines the maximum number of shown bars within the widget. Per default this is set to 12.
Max Number of Stacks
... defines the maximum number of stacks shown in the widget. Per default this is set to 12.
Number of Decimals
... defines the number of decimal places after the decimal point. Per default this is set to 2.
Show Sum Bar
This option adds an additional bar which shows the sum of all values to the end of the widget. Per default this option is deactivated.
This option shortens the value labels shown in the on-hover-legend. For example:
Long Label Example: Total Sale in Dollars of SCOTT: 14.000.625,00$
Short Label Example: SCOTT: 14.000.625,00$
Per default this option is activated.
Legend by Default
The Legend by Default option will only have an effect when the Stacking Field is used. When activated, a legend is permanently shown on the widgets right side. Per default the legend is deactivated.
Show Further Values
Every time the number of different values is greater than the set maximum number of bars or stacks further values are used. The further values bar summarises all values, that are not represented by a single bar or stack.
For example, if there are values for 15 different companies and the maximum number of bars is set to 12, then the last 3 companies will be summarised in a single further values bar.
If the number of maximum bars is raised to at least 15, the 3 companies will be represented by 3 additional bars and the further values bar will disappear. As a result, all bars will be slightly slimmer as more bars need more space.
The further values bar comes in handy, if there are dozens of values and only the "top 10" are of interest.
Per default is option is activated.
Activate this option to show percentages per bar.
Per default this option is deactivated.
Percentage of Value/Category
If the previous option is activated you can choose whether to have the percentages calculated based on the values or on the different categories.