Generating a Level-Based Hierarchy (EX)

About Level-Based Hierarchies

Level-Based hierarchies are a good option if your HR data includes each level the employee reports to, from the top of the hierarchy all the way down to where the employee sits. With Level-Based hierarchies, you don’t necessarily have to know who the employee’s manager is; you just need to know the chain of command for each employee you’re including in the project. This data format is often more common with companies that organize employee data by distinct levels, location, or functional breakout.

Generating a Level-Based Hierarchy

1. Prepare a file of participants for a Level-Based hierarchy by following the directions on the linked support page.
2. Import your participants file by following the steps on the linked support page.
3. Navigate to the Participants tab.
   
4. Navigate to the Org Hierarchies section.
5. Click Create Org Hierarchy.
6. Type a Name for your hierarchy.
   
7. Under Type, select Organizations and their members (level-based hierarchy).
8. If you’d like your hierarchy to include managers, enable Include managers at each level. Then, choose the metadata field that indicates managers in your hierarchy.
9. If your participant file contains Org Unit IDs, then enable Include org unit ID field.
   Qtip: When you use Org Unit IDs, you do not have to manually map your hierarchy units from other projects so you can compare data across projects in your dashboards; instead, units with the same ID will be recognized as the same, even if their names have changed.
   Qtip: There must be a unique Org Unit ID column for each level in the Level-Based hierarchy. For example, if your organization has two levels, “Level 1” and “Level 2”, then you will need two columns for Org Unit IDs: “Org Unit ID 1”, which contains the Org Unit ID for anyone in Level 1, and “Org Unit ID 2”, which contains the Org Unit ID for anyone in Level 2. You must also be careful not to reuse Org Unit field names, which is why we recommend numbering them.
10. Use the dropdown menus to select the metadata fields for your hierarchy levels:
    • Select a level, location, or department field: Choose the metadata field where you define your levels. For example, we simply call our first level “Level 1.”
    • Select a manager value: If you’re assigning managers, select the value that indicates someone is a manager in this level. In this example, we indicated managers with the value “Yes.”
      Qtip: This field is only selectable if you enabled “Include managers at each level” in step 8.
      Qtip: If you chose a Manager Level style metadata instead, your levels may look more like the example image below, where managers at Level 1 have the value “1,” and managers at Level 3 have the value “3.” You can also skip manager levels, like Level 2 below (even if someone has metadata with value “2,” they will not be added as manager, and instead will be a direct report of the level unit).
    • Select an org ID: If including Org Unit IDs, select the metadata field with the Org Unit ID.
      Qtip: This field is only selectable if you enabled “Include org unit ID field” in step 9.
11. Click the plus sign ( + ) to add levels and the minus sign ( – ) to remove levels until you have enough levels for your hierarchy. Map your hierarchy levels using the instructions from the previous step.
12. If you’d like you can adjust the Advanced options. See the linked section for more information about each option.
13. When all of your levels have been added, click Create.

Advanced Options

Click Advanced options when creating a level-based hierarchy to change the following settings:

• Use filters to include only certain people in the org hierarchy: Allows you to limit the people included in the hierarchy based on a metadata value. Once enabled, you can then select a metadata field and determine the criteria for a participant to be included in the hierarchy. In the example below, only participants from a certain hiring date are being included in the hierarchy.
• Include additional metadata to associate with org units: Allows you to specify other metadata to include with your units. You can add and remove fields by clicking the plus ( + ) and minus ( – ) signs next to the field dropdown.
  Qtip: You cannot select fields that are already being used for org hierarchy generation (e.g., ManagerID, EmployeeID). You also cannot select fields that are already being used to configure other org hierarchies in your project. Any fields already being used as additional metadata for another hierarchy in your project will not show up in the field dropdown.

FAQs