Featuring: Dietmar Jeschkeit, Senior Business Intelligence Architect for AIOS GmbH and Community Captain.
In an age of ever-increasing information, it is more important than ever to present that information effectively. While spreadsheets may still be the top priority for financial controllers, management often prefers a clear, visual representation.
The International Business Communication Standards (IBCS) are practical guidelines for designing business communications, which are available for free use under a Creative Commons license (CC BY-SA). The IBCS are used to make reports, presentations, and dashboards as informative as possible in terms of their content design, visual clarity, and semantic notation.
Since BOARD does not support these guidelines out of the box, I have experimented with the available options over time and tried to get as close as possible to the IBCS standards. In the following, I would like to describe a few options.
As an example, I would like to illustrate revenue per customer by comparing two years (could also be any other comparison like ACT vs. BUD).
First, a look at the standard, with the goal shown alongside it:
Here are the step-by-step instructions:
1. Switch Orientation
2. In AXIS CATEGORY set REVERSE, Label Fit Mode to NONE and remove SHOW GRID LINES
3. AXIS PRIMARY remove SHOW GRID LINES
4. In ELEMENTS TITLE and LEGEND remove VISIBLE
5. Time for the LAYOUT, duplicate the PY block and do the same twice for Actual and reorder the blocks
6. Format the 2 Series for PY in the same color (grey) and the 3 Series for AC in black
7. Set HIDE ZEROS and SHOW LABELS for the first and the last Series and define LABEL COLOR as transparent
8. Format TEXT for CATEGORY, PRIMARY and MARKERS based on your needs
9. In the LAYOUT AXES choose if you want to see all customer or only customer with data
10. Duplicate the chart object and align it with the first one on top of each other and disable SHOW LABELS on the top one
11. Do some Calculations in the LAYOUT of the top one (the goal here is to define the smaller series as the basis - block b - and calculate the corresponding deviations from the larger series - block c and d)
12. Now format the series - PY in grey, Base and AC black, Delta- red (232, 76, 61, 1) and delta+ green (146, 208, 80, 1)
13. Change COMBINE MODE for Series Base, Delta- and Delta+ to STACK
14. Set colors for BACKGROUND and PLOT to transparent - you're done with the graph!
15. Now the dynamic header: create a label with the following layout - block b is Entity year, in Object settings define block c as Show value - and place it above the bar chart - set border of bottom to 1
16. Create a label with the following layout for the sentence and define block d as Show value - place it to the right of the previous label
DONE!
You might be wondering why two bar charts are used here. The simple answer is that the bottom bar chart is really just there to label the data. In a bar chart with different series types, BOARD no longer places the numbers at the end of the bars, but inside them.
To wrap things up, here are a few more examples that can also be implemented with a little "creativity" (feel free to contact me).
1. The deviation is not a separate object but is implemented within the graphic object using blocks. This keeps the graphic dynamic.
2. A combination of a waterfall chart and a bar chart:
Share your thoughts below!