Breakdown sources specify which
unique elements a breakdown contains. A breakdown source is defined as a set of
records from a table or database view or as a bucket group. Multiple
breakdowns can use the same breakdown source.
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
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.
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.
Navigate to New.
Give the breakdown source a meaningful Name.
For the Facts Table, select the table that the breakdown
source gets elements from.
For example, for the breakdown source to specify user groups as elements,
select Group [sys_user_group].
In the Field table, select a field that contains a
unique value for every record.
This field is usually Sys ID.
Set the Conditions for filtering the element list.
[Table] [is] [Incident]
[Element] [is] [Category]
[Language] [is] [en]
[Inactive] [is] [false]
[Inactive] [is] [empty]
To see how many records match the selected conditions, click
In Label for unmatched, write a custom label to use if a
record from an indicator source does not contain a valid element value in a
The default label is Unmatched.
In the Security tab, set whether to exclude or include
breakdown source elements by role based on element security lists.