rolling 12 months bar chart problem

[MarkRoosemont]

So I created a bar chart which has one bar per month. I'd like to view this as 12 rolling months. When I choose relative date: 1 year it just adds the number from january this year to those of january last year. But what I want to see is bar number 1: january 2020, bar number 2 february 2020, ..., bar number 13 january 2021

Is this possible?

Thanks

[MarkRoosemont]

Thanks, step 1 and 3 worked as a charm. But step 2 not so much until I saw the arrows in the upper right corner of the chart. After clicking on a couple of them, I suddenly got the view I was looking for! Thanks!

[amitchandak · Accepted solution]

@MarkRoosemont , I think you might have to display last 13 months.

Second, you have to use month yearmonth  on axis

or  Year and month both on axis with concatenated label off and sort on year month