Skip to content

YEAR-OVER-YEAR BY PERIOD PLOT

The year-over-year by period chart compares the weekly average actual values to the corresponding previous year weekly average values calculated by year, semester, quarter and month.

year_over_year_by_period

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.

year_over_year_by_period (1)

PLOT DETAIL

The plot is run at the total plotted data level for the chosen metrics

year_over_year_by_period (2)

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

year_over_year_by_period (3)

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

image-20220419132420981

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

OTHER OPTIONS

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

A few additional options are available for selection.

image-20220419132356970

X 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.

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.

EDIT AND MOVE LABELS

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

year_over_year_by_period (4)

...you might want to move the AC legend label.

year_over_year_by_period (5)

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

Draw and edit your shapes.

year_over_year_by_period (6)

ADD PLOT MESSAGE

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

image-20210907103349777

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

image-20220419155010571

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

Your message will appear above the chart title. Adjust its position with the mouse if necessary

image-20220419155113689

The downloaded image of the chart contains the message.

image-20220419155203251

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 grey line by moving them around with the mouse.

year_over_year_by_period

Back to top