Running Sum
A running sum calculation creates a sum of the previous value to the value in the partition, thus accumulating the data points that can show trends or insights in the data.
Figure 3.32: Example of Running Sum
Using a sum is the default option. You can also choose to use an average, minimum, or maximum:
- Average: This option will average the current and previous values
- Minimum and Maximum: These two options will replace the value with either the lowest or highest value in the partition
By setting the Restarting every option, you can select the dimension in the view by which the data is grouped, causing the calculation to restart for each partition defined by that dimension. This is shown in Figure 3.33:
Figure 3.33: Running sum restarting every year
Difference and Percent of Difference
These functions allow for comparison between data points, highlighting changes in the values and showing either...