Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

rolling 12 months bar chart problem

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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , 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

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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!