X- Axis Month to show 13 months (rolling)

[Anthony stark]

Hi Guys,

I have a line chart an bar char that i need to confiure the X-Axis to show just 13 months of data at any given time. For example if the data starts this month March, as the data is added to the chart it should keep on until February next year (13 months), then reastart in march 2021.I basically want it to capture a rolling 13 months of data continously . How can i configure the X-axis to achieve this Your help os appreciated.

Thanks in advance

[Shashank Gurnalkar]

You can try to limit the data by using the following expression:

[Date_Column] >=dateadd("mm",-13,Date(2021,03,01))This will display the data from the previous 13 months of the given date i.e. from 1st Feb 2020. Otherwise, you can modify the parameters according to your needs.

[Anthony stark]

Thanks Shashank

[Tyger Guzman 2]

You can also set the show/hide item rule(s) and have the top Nth dates only show. That way it will work with any filtering of data.