Spotfire调试经验——累计值的动态计算（Dynamic accumulated value calculation in Spotfire visualization）

各年度销售额的直方图如下所示：

问题：如何展现出各时间段内（年、季度、月、星期、天、小时、分、秒）的累计销售额？

解决方案：单击图标左侧Y轴销售额，编辑公式为“Sum([Sales Total]) OVER (AllPrevious([Axis.X]))”，即可实现该要求。

按季度计算的累计销售额：

按年度汇总的累计销售额：

--------------------------------------------------------------------------------------------------------------------

以下内容摘自官网文档：

The OVER functions are used to determine how data should besliced, for example, relative to time periods. For more information, see OVERin Custom Expressions and Advanced Custom Expressions.

Uses all nodes, including the current, from the start of thelevel. This can be used to calculate the cumulative sum. 

Examples:

Sum([Sales]) OVER (AllPrevious([Axis.X]))

Sum([Sales]) OVER (Intersect(Parent([Axis.X]),AllPrevious([Axis.X])))

以下内容摘自培训资料：

The AllPrevious() method allows givesan expression access to all of the previous nodes in a plot dimension. Note that AllPrevious() is inclusive of itself, the current marker.

A good example of using the AllPrevious method is creatingcumulative sums or percentages.