Define a breakdown source
-
- UpdatedJan 30, 2025
- 4 minutes to read
- Yokohama
- Performance Analytics
Specify a facts table to serve as a data source for breakdowns. Apply conditions to specify the elements for this breakdown source.
Before you begin
Roles required: pa_data_collector, pa_admin, or admin. The breakdown source creator needs access to the table and reference column that the indicator source uses.
About this task
Always use a facts table with a field that has a unique value for every record, usually Sys ID. For example, the Incident.Category breakdown source takes its elements from the
Choice table. The elements are identified by the Sys ID field. The breakdown source filters the choices to those that are on the Incident table, in
English, and not inactive.
Tip: As in this example, if you use Choice [sys_choice] for the facts table, put conditions on the Table, Element, and Language fields. Also filter out Inactive records.

The breakdown source uses the following records from the Choice table:


Note: The Choice table includes every possible choice from every table, which is why it has Table and Element columns. Most other facts tables you would use for a breakdown source are simpler.
Procedure
What to do next