PA report to show count as well as % for closed and non completed incidents

[dhanu3]

We are creating PA report to show total count of closed incidents vs total pending incidents and % of both in single widget on dashboard.

For this widget we want Category breakdown. We have used category breakdown on each indicator and it is working on indicatory level. but on widget breakdown is not working. when we select breakdown in breakdown field and if element is kept as empty system set it as unmatched and on dashboard wrong data get displayed.

We are using time series widget.

Please note category is custom choice type fields and in breakdown source we are referring to choice table.

[M Iftikhar]

Hi @dhanu3 ,

The “Unmatched” issue in your Time Series widget is happening because the Category breakdown isn’t mapped correctly to your Incident table/field. In newer UI versions, you won’t see a separate Breakdown Mappings module in the navigator — instead, mappings are managed inside each Breakdown record.

How to fix it:

1. Go to Platform Analytics Administration > Breakdowns.

2. Open your Category breakdown.

3. In the form, scroll to the Breakdown Mappings related list.

4. Click New and configure:

   • Facts table: Incident [incident]

   • Field: your custom Category field

   • Leave Scripted unchecked unless you need custom logic

5. Submit and then rebuild your PA data collection jobs.

Once the mapping is in place, your widget will correctly associate incidents with their category elements. This removes the Unmatched grouping and ensures the breakdown displays properly on dashboards.

Thanks & Regards,
Muhammad Iftikhar

If my response helped, please mark it as the accepted solution so others can benefit as well.

[dhanu3]

Hi @M Iftikhar ,

Yes I have added breakdown mapping as mentioned, but it is not working. I tried using scripted breakdown also, but no luck.

Breakdown source I have applied on sys_choice table using sys id field and referring to Incident table element category.

[M Iftikhar]

hi @dhanu3 ,

Since a scripted breakdown didn’t work, the issue is likely how the Breakdown Source is set up for your choice field.

For the Category field on Incident:

• It stores the integer value of the choice, not the sys_id.

• So your breakdown source should use the value field from the sys_choice table, not sys_id.

How to Fix It

1. Breakdown Source: sys_choice table, Breakdown Field = value.

2. Breakdown Mapping:

   • Facts Table: Incident [incident]

   • Field: your Category field (category or u_category)

Once this is set up, just rerun the PA Data Collection Job. This should correctly associate your incidents with the categories and remove the “Unmatched” grouping.

Thanks & Regards,
Muhammad Iftikhar

If this helped, please mark it as the accepted solution so others can benefit too.