Introduction

Bar charts can be used to group data and to compare certain metrics. The bars are displayed horizontally.

Adding data to a bar chart

Follow these steps to add data to a default bar chart.

See illustration below.

After selecting the attribute, the dashboard is split in different bars and after each bar the number of records per row is displayed.
In the above example, the dashboard now shows the number of records per Invoice owner.

📘

Note

By default the value displayed is the record count. In the above example the numbers reflect the number of invoices.

Changing the values

It is possible to display different values in the chart by selecting a metric, for example, the average amount instead of the default number value. In this case you must create a metric that calculates the average amount.

Follow these steps to display a different metric in the chart.

📘

Note

If you want to enable end-users to switch between different values in the chart, you can create different metrics, and add them to a metric selector. In that case, you select the metric selector from the Metric drop-down list.

Splitting the chart

You can split the data on the chart by adding columns. Select an attribute from the Column drop-down list in the Grid panel to split up the data by the selected attribute and display the information in different columns. See illustration below for an example where the data is split up per Supplier type.

Column sorting

By default the data is sorted alphabetically by category in ascending order. The options in the Grid panel enable you to change the sorting of columns and/or the direction. See illustration below.

📘

Note

Since the sorting applies to columns, the Sort columns and Sort direction options are only available if the the Column attribute is set in the Grid panel.

If you select the By sum of metric option from the Sort columns drop-down menu the data in the chart is sorted by the sum of the metric values of the metric displayed in the chart. The Sort direction option enables you to select whether the data should be sorted in ascending or descending order.

Adding a compare bar

It is possible to add a compare bar to the chart which can be used to compare periods. In this case, you must create a period filter and add it to the dashboard. See illustration below for an example.

The dashboard contains the Event end period filter and the results or the selected month are displayed. The results of the previous month are indicated by the light-blue colored bar, which allows users to compare the values between the two periods.

Follow these steps to add a compare bar to the chart.

📘

Note

If you select the Compare bar option, the compare color is automatically determined based on the chart colors. If you want to change the compare color, you must change the color in the period filter.

Adding a drilldown

You can define a drilldown attribute for a main attribute. Both the main attribute and the drill-down attribute must be present in an attribute selector on the chart and the selector must be on the X-axis.

The attribute selector is used as a level in the chart. If the attribute that is selected in the selector has a drilldown attribute defined for it, a drilldown icon is added to the bar chart.

Defining a drilldown attribute

Follow these steps to define a drill down attribute.

📘

Note

If you want to drill down to an attribute which is not available in the table to which the main attribute belongs, you have to create an additional expression to resolve this.

For example, if you want to create a drilldown from Variant type to Variant. Assume the Variant type attribute type is defined in the Cases_base table, but not in the Cases table where you have defined Variant. To enable the drill down to Variant you must create an expression in the Cases table to define the Variant type. In the Variant type expression you select Variant as the Drilldown attribute.

Adding the drilldown to the chart.

Follow these steps to add the drilldown to the chart.

The drilldown icon is added to the bar chart. See illustration below.

When a user clicks on the drill-down icon in the chart, the drilldown attribute is automatically selected in the attribute selector and a filter based on the top level attribute is created the Filters panel.
To drill up the user must select the main attribute from the attribute selector, or use the Back button in the web browser. This automatically removes the filter that was created from the drilldown.

Adding context columns

You can define metrics that determine the context of the main metric to provide a better understanding of the main metric displayed on the dashboard. Contexts are displayed as tooltips on charts. On bar charts, contexts can also be added as additional columns. This enables users to sort on the contexts.
See Contexts for more information.

Follow these steps to create a bar chart with context columns.

Related information

See Metrics.
See Contexts.