Skip to content

MULTI-TIERED COLUMN PLOT

The multi-tier column chart, inspired by this IBCS template, contains three parts.

image-20211107161512928

In a first tier, this plot compares different scenarios in a grouped column chart. The second and third tiers show different absolute and relative variance charts. This 3-tier chart can be used to analyze the temporal development of different scenarios.

PLOT DETAIL

The plot is run for all metrics at the total level...

image-20211108130121785

..and, for each dimension, it is run for the chosen metric.

image-20211108130211780

The most recent, Actual, value is show with in black. The less recent PY value is shown with in grey. Red is "bad" while green is "good."

SAVING THE PLOT

To save the plot as a PNG file, hover the top right side on the chart. A menu will appear. Click on the camera icon.image-20211107162221937

OTHER OPTIONS

Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.

Additional options are available for selection.

image-20211107162251771

METRIC AND DIMENSION SELECTION

You can choose the metric to plot, for instance "COGS", as well as the dimension to slice by item.

image-20211107162335731

The COGS metric will be plotted by Region.

image-20211108142057427

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.

image-20211108142136036

ENABLE PLOT MESSAGE

It is possible to add messages to the chart, in the style of the already mentioned IBCS template.

image-20210907103349777

Enable messages by setting the "enable plot messages" widget to True.

image-20211107162758281

You can find the "enable plot messages" checkbox in the Run widget expander.

image-20210907110650891

Hit the Submit button.

image-20210907110800029

A text box will appear above each chart.

image-20211107162823663

Add your message, one chart at a time.

image-20211107162930124

Once you have finished writing the message for a chart, click on the 🚀 Submit button.

Your message will appear above the chart title

image-20211107163030967

Now write another message on the text box of a different chart.

image-20211107163413353

Click submit. Your second message appears above the second chart.

image-20211107163519458

The downloaded image of the chart contains the message.

image-20211107163542888

Back to top