Stack Date Values per Month
Objective
- If you want to build a stacked chart with date values and stack them per month but the date values are not on the same day, the data points are not stacked.
Solution
- Open axis customizing
- X axis (DateTime)
IntervalType
= "Months" - Only show months on the X axisLabelFormat
= "MMM" - Only show month abbreviation as labelsRoundToIntervalType
= "true" - Round date values to beginning of the month
The ticks on the axis are the end of a month, not the beginning of the next one.