Hengshi Documentation

Cumulative Calculation

Cumulative calculation appears only when the dimension is date.

Cumulative calculation occurs when the aggregation method for the date dimension is: minute, hour, day, week, month, or quarter.
Cumulative calculation does not occur when the aggregation method for the date dimension is: millisecond, second, day (across weeks), day (across months), month (across years), quarter (across years), or year.

Types of calculations supported by cumulative calculation:

• Sum
• Average
• Maximum
• Minimum
  

The repeat cycle for cumulative calculation is units bigger than the current selected date dimension aggregation method. For example, if "minute" is selected, the repeat cycle list supports all units bigger than "minute": hour, day, week, month, quarter, year.
When the date dimension aggregation method is "year," there is no unit bigger than "year," so cumulative calculation will not occur.