This article describes how to use the Percent of Group analytic function in Arcadia Instant.
We are using the Basic Visual for Aggregates to demonstrate how to use the Percent of Group analytic function.
sum(population)
field on the Y Axis shelf.In the Analytic Function: Percent of Group modal window,
[Optional] If you examine the expression in the Enter/Edit Expression interface, it shows that the function has the following form:
(sum([population]) / sum(sum([population])) over (partition by [year])) as 'percent(population)'
Click Refresh Visual.
Notice the change in the Y axis and tooltips, from displaying the
sum(population)
in millions to population
as a
percent.