Percent of Group Analytic Function

This article describes how to use the Percent of Group analytic function in Arcadia Data.

We are using the Basic Visual for Aggregates to demonstrate how to use the Moving Average analytic function.

  1. Click the field on the measurement shelf, in this case, the sum(population) field on the Y Axis shelf.
  2. In the Field Properties menu, expand Analytic Functions, and select % of Group.
    Applying Dense Rank
  3. In the Analytic Function: Percent of Group modal window,

    1. In Select aggregate for this measure, leave the default Sum. The other aggregation options are Count, Approximate Distinct Count, Exact Distinct Count, Minimum, Maximum, and Average.
    2. Under Select entities over which to calculate percentage, select year. This is the grouping that applies when calculating the moving average.
    defining the Percent of Group analytic Function
    Analytic Function: Percent of Group
  4. Click Apply.
  5. [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])) * 100 as 'percent(population)'
  6. Click Refresh Visual.

  7. Notice the change to the appearance of the visual, and the change in values that appear on the tooltip.

    Percent of Group Analytic Function Visual
    Percent of Group Analytic Function Visual