Skip to main content

How to create hierarchies

This guide explains hierarchies in Aragorn Analytics—nested structures that let you group analytics and drill from high-level totals into deeper levels.

T
Written by Tyrone Marhguy

What is a hierarchy?

A hierarchy is how an organization breaks into nested sections. Each person (or location) sits on a path from the top level down to a leaf.

Org example:

  1. Company (top)

  2. Department (for example, product engineering)

  3. Cost center (where time is billed; some companies budget strictly by cost center)

Someone can be in Engineering and still bill to cost center A while a teammate in the same department bills to cost center B.

Large organizations may have multiple companies or subsidiaries under one entity (for example, different business lines). The same department name can exist in more than one company, so hierarchy paths identify where a person sits (company → department → cost center).

Location example: Country → state/province → city (US states vs Canadian provinces, then cities).

Why create hierarchies?

Hierarchies make it easy to build stories that group by hierarchy and let executives drill:

  1. See headcount by country (or by company).

  2. Click into a country/company to split by state/department.

  3. Click again to split by city/cost center.

  4. Continue until you reach the people behind the number.

Example — location: USA 300, Canada 400, Mexico 500 → open USA → Texas 10, California 20, … → open Texas → Dallas 2, Houston 1, …

Example — org hierarchy: Company total → Engineering 8 / Sales 2 → Engineering cost center A (find a specific person) vs cost center B.

Create or configure a hierarchy

  1. Open Analytics → Manage Analytics.

  2. Open the Hierarchies area.

  3. Create a hierarchy and define its levels in order (for example, Company → Department → Cost Center, or Country → State → City).

  4. Map each level to the Ontology / data fields your organization uses for that slice.

  5. Enter data for the required fields.

  6. Save the hierarchy.

Use hierarchies in stories

  1. Create or open a story.

  2. Choose a calculation (measure or metric), such as headcount.

  3. Group by the hierarchy (instead of—or in addition to—a flat dimension, depending on product options in your environment).

  4. Viewers drill level by level from the visual.

Did this answer your question?