YEAR-OVER-YEAR BY PERIOD
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.
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.
The plot is run at the total plotted data level for the chosen metric
...and for each dimension .
To choose the metric, open the expander below the "Plot type" widget and select the metric with the Y-axis metric widget
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.
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
A few additional options are available for selection.
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..
...you might want to move the AC legend label.
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.
Draw and edit your shapes.
ADD PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Add your message in the text box, one chart at a time.
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
The downloaded image of the chart contains the message.
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.