Year-over-year waterfall
The year-over-year column chart, inspired by this IBCS template, contains three parts.
The lower tier of this chart shows grouped columns for AC and PY combined with a horizontal waterfall chart showing the absolute variances. An additional tiers show the relative variances to PY.
The plot is run for at the total level and, for each dimension, it is run for the chosen metric.
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."
The app will visualize Forecast (FC) data as hatched in the monthly bar charts.
To plot the items as small multiples, choose the dimension on which to plot them.
The small multiples do not show the percent differences.