Skip to content

ACTUAL VS PREVIOUS YEAR PLOT

The actual vs previous year chart shows this year vs previous year performance along different time spans.

PLOT LOGIC

The chart below compares the average weekly values of unit price, units and amount of the present year (AC) to the corresponding values average weekly values of the year before (PY).

From the left, the weekly average values are for the year, the most recent six months (compared to the corresponding six months of the previous year), the most recent quarter (compared to the corresponding quarter of the previous year), and the most recent month (compared to the corresponding month of the previous year).

The red areas are "bad" while the green areas are "good". In this particular example higher amounts are "bad" because the example is about costs.

image-20210419150156640

The increase in present year amount vs last year amount appears consistent throughout the year, with a peak in the most recent quarter, driven by a spike in price.

PLOT DETAIL

The plot is run at the total plotted data level for all metrics (in this case Price, Units and Amount)

image-20210419150350422

...and for each dimension for a specific metric chosen by the user.

image-20210419150513541

To choose the metric, open the expander below the "Plot type" widget and select the metric with the Y-axis metric widget

image-20210419150644879

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-20210419150815743

OTHER OPTIONS

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

Four additional options are available for selection.

image-20210325122018377

By default, the seven 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.

Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.

The plot can show the two periods one alongside the other,...

image-20210419151144280

...or, if the "index vs a year ago" option is chosen, as the ratio of AC on PY.

image-20210422185243628

ENABLE PLOT MESSAGE

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

image-20210907103349777

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

image-20210908110046644

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-20211014201943006

Add your message, one chart at a time.

image-20211014202033736

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

Your message will appear above the chart title

image-20211014202138128

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

image-20211014202218016

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

image-20211014202325121

The downloaded image of the chart contains the message.

image-20211014202353149