MULTI-TIERED BAR PLOT
The multi-tier bar chart, inspired by this IBCS template, can by used to analyze the data structure of different dimensions.
The first tier of this template compares different scenarios in a grouped bar chart. The second and third tiers show different absolute and relative variance charts.
The plot is run for each dimension.
The most recent, Actual, value is show with in black. The less recent, or Plan, value, is shown with in grey or outlined white. Red is "bad" while green is "good."
SAVING THE PLOT
To save the plot as a PNG file, click on the small circle to the right of the legend, and select "save as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
By default the Amount metric will be plotted. You can choose the metric to plot, for instance "COGS".
The COGS metric will be plotted.
SMALLER ITEMS AGGREGATION
By default, the four top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
ENABLE PLOT COMMENTS
It is possible to add comments to the chart, in the style of the already mentioned IBCS template.
Enable comments by setting the "enable plot comments" widget to True.
You can find the "enable plot comments" checkbox in the Run widget expander.
Hit the Submit button.
A text box will appear above each chart.
Add your comment, one chart at a time.
Once you have finished writing the comment for a chart, click on the 🚀 Submit.
Your comment will appear above the chart title
Now write another comment on the text box of a different chart.
Click submit. Your second comment appears above the second chart.
The downloaded image of the chart contains the comment.