Displaying month rolling (-90 days to today) in bar chart

[jens231]

Hello,

I'm trying to display actions in a bar chart in the following way: Number of actions each month from today and 180 days forward. I got a requirement to show month with 0 actions. See chart below (month 1 and month 2 = 0).

Therefor I use the chart properties "Dimension Axis --> Scale --> Static Min and Static Max."

For the graph looking forward 180 days it works since im not changing year, only looking in 2023 so far.

But when Im doing the same method for looking back 90 days from today I get a problem.

Without the static Max I get the following graph:

From what I understand Im not able to get January visable in the second graph since its the first month. 

Do you know how I could solve this problem? Im thinking I need a base 12 system --> 1-12 repeating continuously.

Best regards,

J