We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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