Skip to content

YEAR-OVER-YEAR COLUMN

The year-over-year 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 at the total level...

year_over_year_column

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

year_over_year_column

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

If the dataset has Plan vs Actual data and Previous Year vs Actual data, it is possible to chose what to compare.

image-20220111133306291

Plan data will be shown in white, Forecast data will be shown hatched. Actual data will be shown in black. Previous year data will be shown in dark grey. Forecast data must be tagged in the dataset as "FC".

multi_tier_column (4)

SMALL MULTIPLES PLOT

To plot the items as small multiples, set the Plot Small multiples widget to True

image-20220619151633905

and hit the Submit button.

year_over_year_column (3)

The small multiples plots show the yearly values and differences in values integrated in the bas, not the percent differences.

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 image-20211219163817911

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 for each Manufacturer.

multi_tier_column (3)

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.

multi_tier_column (4)

EDIT AND MOVE LABELS

You can edit and move around plot titles and labels. In this chart..

multi_tier_column

...you might want to move the PY legend label up.

multi_tier_column (1)

ANNOTATE CHARTS

It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.

Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.

image-20211219164457091

Draw and edit your shapes.

image-20211219164616599

ADD PLOT MESSAGE

It is possible to add messages to the chart, in the style suggested by the IBCS standard.

image-20210907103349777

Add your to the text box message, one chart at a time.

image-20211219164905741

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

Your message will appear above the chart title. You can save the chart with the message and the annotations.

multi_tier_column (4)

CHART TITLE

By default, the chart title is set on three lines, the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").

You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.

year_over_year_column