Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi , @samvile18
I think can meet the requirements by using Set analysis and adding two scales to the bar chart with Month as dimension.
eg.
Hi , @samvile18
I think can meet the requirements by using Set analysis and adding two scales to the bar chart with Month as dimension.
eg.