Skip to main content

OrgChart Help Guide

Percent Example

Audience

Audience: Administrators

Overview

A Percent Aggregated Field counts the number of employees with a value for the selected field(s), divides the number by the total amount of employees, and then displays the results as percentages.

For example, you could create a Percent Aggregated Field to find the percentage of women and men in each department.

The following article provides step-by-step instructions for creating a Percent Aggregated Field.

Defining a Percent Aggregated Field
  1. Log in to OrgChart.

  2. Click on the Mode Switcher icon in the Top Toolbar, and then select the Setup option. The Setup panel is displayed.

    Setup_ChartSettings_Select.png
  3. Click on the Chart Settings tile, and then click on the Fields & Formulas tab in the left side menu.

  4. Click on the f(x) Create button, and then select the Aggregated Field option.

    5_2_2_Fields_and_Formulas__Select_Aggregated_Field.png
  5. Enter a name (e.g., Gender Breakdown) for the Aggregated Field in the Formula Name text box.

  6. Select a field (e.g. Gender) from the Fields section, and then click and drag it into the Columns section.

  7. Select another field (e.g. Department Name) from the Fields section, and then click and drag it into the Rows section.

  8. Click on the 5_2_RoundPlus_icon.png icon (to the right of the Results heading), and then select the Count option.

    Agg_Field_Percent_Example.png

    Note

    You can filter the values that are included in the Aggregated Field calculation. Reference steps 6 and 7 of the Aggregated Fields article for more information on filtering.

  9. Mouse over the Count operation, and then click on the AggField_Icon.png icon. The Percent_Icon.png icon is displayed.

  10. Click on Save. The Aggregated Field is added to the list of Fields & Formulas .

  11. Click on Save and then Refresh. The field can now be used in an Enumerated Table.