Create a vertical or horizontal bar chart
A bar chart presents categorical data with rectangular bars with heights proportional to their values.
In LogAlto, you can create a vertical or horizontal bar chart.
In a vertical bar chart, the X axis of the chart shows the specific categories being compared, and the Y axis represents a measured value.
When to use a bar chart?
The barchart is useful to compare relative amounts of each categories - like compare number of persons per gender or per region.
It requires at least 1 numerical field (what will be calculated) and 1 or 2 categorical variable (what will be compared).
In some cases, a stacked bar chart (article here) may be more useful.
If you need to compare 3 or more categorizations/dimensions, maybe a radar chart (article here) or a pivot table would be a better idea (article here).
Create a bar chart
To create a bar chart:
- Click "Analytics" in the main menu (left)
- Click the + sign
- To create the new analytics report, you must:
- Enter a name
- Select a dataset
- Select an output type (in this case: Vertical bar chart or Horizontal bar chart)
- Click Save
- A draft data visualization will be displayed
- Configure your report:
- Click the "Toolbox icon" to open the configuration panel
Configure the chart to fit your needs
- Click "Generate" see the result
- Click "Save" to save the report
- If you open this chart in the future, it will be updated to reflect newly added data. So if you need to keep the report that reflects the current data, you must export it.
Configure the bar chart
In the configuration panel of the bar chart, you will see the following parameters:
Parameter | Details | Example or Link |
---|---|---|
Calculation method | Allows to select the calculation that will be applied (Average, Sum, Count, etc.) | For more details, you can read the "Calculation methods" article. |
Field | The field on which the calculation will be applied. | This must be a numerical field. (number) |
Display the value as a percentage | If the labels are displayed, you will see the proportion of the slice | Example: The dataset has 15 rows. 3 of them are in category A. Then if this box is checked, it will display "20%" instead of displaying "3" in the bar representing category A. |
X axis or bar groups (for horizontal bar charts, the parameter is "Y axis") | First field that will be compared (categories represented by bars) | (this could be gender/region/budget line, etc.) |
Coloring of bars | Second field that will be compared (sub-categories represented by various colors) | (this could be gender/region/budget line, etc.) |
Distinct values | Allows to count items only once and avoid duplicates | Example: a participant could have attended multiple activities of the same type. If you need to count participations only once per attendee/type, then you need to select the Attendee field as a distinct value. For more details, you can read the "Distinct count" article. |
Position of labels | Allow to specify if you want to display the values on the chart. | Hide, inside at the end, or inside at the start of each bar. |
Dropdown lists: use predefined colors | Allows to color bars using the colors attributed to each category. Otherwise, colors will be attributed randomly. | For more details, you can read the "Manage system lists" article. |
Axis limits: minimum and maximum value | Allows to specify the minimum and maximum values to display on the axis. | This is optional. |
Filters | Allows to filter out part of the dataset | This is optional. |
Example
In this example, we want see to compare the values (male vs female) of an indicator per quarter.
This example uses the "Indicator disaggregated values" dataset.
Parameter | Chosen option for the parameter |
---|---|
Calculation method | Sum |
Field | Overall cumulative |
X axis | Actual quarter |
Coloring of lines | Gender |
Distinct values | not applicable - empty |
Position of labels | Hide |
Dropdown lists: use predefined colors | Checked (yes) |
Axis limits | Minimum: 0 (otherwise, the Y axis would start at 45: the min value recorded) |
Filters | The indicator for which we want to compare the male vs female values per quarter |