Rolling 12 Month Comparison

samvile18 — Tue, 12 Dec 2023 13:33:13 GMT

Hi all,

I know this can be done and I'm really close to it, I just can't seem to get the syntax quite right.

I have data laid out like this:

I need to create a graph which shows the last 12 months rolling whilst comparing this years data with last years. Does that make sense?

So a monthly bar chart showing each months variance to the year before, across a rolling 12 months.

Any help would be greatly appreciated - I've got the comparison bit done, I think - it's the rolling 12 months I'm struggling with.

Re: Rolling 12 Month Comparison

MeehyeOh — Wed, 03 Jan 2024 00:16:49 GMT

I think can meet the requirements by using Set analysis and adding two scales to the bar chart with Month as dimension.

eg.