PA Breakdown with Buckets and Scripted Mapping Showing 0%

Singhdeep70
Tera Contributor

I am trying to build a Performance Analytics indicator in ServiceNow to show Incident Aging using buckets and breakdowns.

This is my first time working with buckets, scripted mappings, and breakdown sources in PA, so I may be missing an important configuration step.

Current Goal:
I want to group active incidents into age ranges like:

  • 0-2 Months

  • 3-5 Months

  • 6-8 Months

  • 9+ Months

and display them using a breakdown on an automated PA indicator.

What is currently working:

  • Indicator collection works correctly

  • Scheduled collection job runs successfully

  • Indicator scores are collecting correctly

  • Parent score shows 109 active incidents

  • Breakdown rows appear in the scoresheet

Problem:
The breakdown rows always show 0% / empty values even though the parent indicator score is collecting correctly.

Current Configuration:

  1. Indicator

  • Type: Automated

  • Aggregate: Count

  • Collect breakdown matrix: true

  • Collect records: true

  1. Indicator Source

  • Facts table: Incident [incident]

  • Condition: Active = true

  1. Breakdown

  • Automated breakdown

  • Attached to indicator

  1. Bucket Group
    Buckets configured as:

  • 0-2 Months → 0 to 2.99

  • 3-5 Months → 3 to 5.99

  • 6-8 Months → 6 to 8.99

  • 9+ Months → 9 to 9999

  1. Breakdown Mapping
    Currently using scripted mapping.

 

Important Observation:

  • Parent indicator score collects correctly

  • Breakdown rows are visible

  • But breakdown values remain empty / 0%

I also noticed confusion around:

  • Breakdown Source using Bucket 
    vs

  • Normal Incident table breakdown source

 

If possible, could someone please provide the complete step-by-step process from:

  • Breakdown Source

  • Bucket Group

  • Breakdown Mapping

  • Indicator

  • Collection Job

  • Aggregation

 

0 REPLIES 0