Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Breakdown applied to Glide List field returns breakdown scores totaling more than indicator score - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Breakdown applied to Glide List field returns breakdown scores totaling more than indicator score
KB0859759

Breakdown applied to Glide List field returns breakdown scores totaling more than indicator score


831 Views Last updated : Jan 2, 2025 public Copy Permalink
KB Summary by Now Assist

Summary

Unlike Reference or Choice fields, List fields can store more than one value (sys_id).

When a breakdown is applied to a List field, each sys_id in the List field is evaluated to find a matching breakdown element. The number of evaluated sys_ids is therefore usually higher than the number of records that contain the List fields. As a result, breakdown scores can be higher than the overall indicator score.

This behavior can be seen most easily with indicators with the Count aggregate. With a breakdown of a Reference or Choice field, the total breakdown scores are always equal to or less than the overall indicator score. Each Reference or Choice field has one value, there is one field per record, and the count of all the Reference or Choice values cannot be more than the Count of records for the indicator. However, if you have a breakdown on a List field, each record can have multiple values in its List field. Each of these values that matches a breakdown element contributes to the Count for the breakdown score on that element. You could end up with an indicator with a score of 10, representing 10 records, where one of the breakdown elements on that indicator has a score of 15, representing 3 records with 5 List field values each.

Similarly, if you define breakdown relations on the elements of a single breakdown that is applied to a List field, the scores of the child elements can be greater than the score of the parent element.

For Field breakdown mappings, this behavior is expected. To work around it, create a Scripted breakdown mapping where the script treats all the values in a List field on one record as a single score.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.