Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jens231
Contributor
Contributor

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

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).

jens231_0-1673344010794.png

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

jens231_1-1673344226524.png

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.

jens231_3-1673344426079.png

 

jens231_2-1673344406722.png

Without the static Max I get the following graph:

jens231_4-1673344483977.png

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

Labels (1)
0 Replies