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 axis
      • LabelFormat = "MMM" - Only show month abbreviation as labels
      • RoundToIntervalType = "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.