This article describes how to use the Running Total analytic function in Arcadia Enterprise.
We are using the Basic Visual for Aggregates to demonstrate how to use the Running Total analytic function.
sum(population)
field on the Y Axis shelf.In the Analytic Function: Running Total modal window,
Under Select the sort order, you can specify the order of sorting. This order specifies what the row is, and the row where the value is taken. If your visual already specifies sorting order, these values appear in the modal.
You can add additional sort parameters, by clicking the (add/plus) icon.
Here, leave the default order: year ascending, followed by country ascending.
[Optional] If you examine the expression in the Enter/Edit Expression interface, it shows that the function has the following form:
sum(sum([population])) over (partition by [year] order by [year], [country]
rows between unbounded preceding and current row) as 'running total(population)'
Click Refresh Visual.
Notice the change to the appearance of the visual, and the change in values that appear on the tooltip.