Breakdown mappings

Breakdown mappings allow you to define relationships between the indicator source table and the breakdown source table. This behavior allows you to use one breakdown for multiple indicator source tables.

For example, you can map the sys_id from Group [sys_user_group] records in the Group.Active breakdown source with Incident table Assignment group values. You can use the same breakdown to create additional mappings between the Group.Active breakdown source and other tables and fields that reference the Group table, such as the CMDB Support group field.

Create a breakdown mapping

Create a breakdown mapping to define a relationship between an indicator facts table and the breakdown source elements.

Before you begin

Role required: pa_admin, pa_power_user, pa_admin, or pa_data_collector

Procedure

  1. Navigate to Performance Analytics > Automated Breakdowns or Manual Breakdowns.
  2. Select the breakdown you want to map to an indicator facts table.
  3. In the Breakdown Mapping related list, click New.
  4. Select the Facts table that contains values you want to map to breakdown elements. This is the source table for indicators that you want to break down.
  5. Do one of these actions:
    OptionDescription
    Use a field to map values to elements Select the Field that contains the values to map to breakdown elements.

    For example, when mapping the Incident table with the Groups.Active breakdown source, select the Assignment group field to break down scores based on the assignment group of each incident.

    Use a script to map values to elements Select Scripted, then select the Script that defines the association between indicator records and breakdown elements.
  6. Click Submit.
  7. Repeat steps 3-6 as needed to define additional mappings.