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.
Reporting on the task table and grouping by state shows incorrect values - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • Reporting on the task table and grouping by state shows incorrect values
KB0639093

Reporting on the task table and grouping by state shows incorrect values


6440 Views Last updated : Jun 19, 2025 public Copy Permalink
KB Summary by Now Assist

Description

Reporting on the task table using the state field has discrepancies like:

  1. Adding a filter for state field in the report brings up a drop down of values - where some of the values from the child derived tables are missing and the drop down options seem different 
  2. Creating a report of type donut displays values different from what is displayed if a list report is created with the same filters 




Steps to Reproduce

  1. Navigate to https://demonightlyjakarta.service-now.com/
  2. Navigate to Reports > Create New to create a new report
  3. Give the Report a title test and select task as the table
  4. Create a report of Type Donut with filter condition created on last month and group by State
  5. Try to create another filter condition State is one of and pull down the list of drop down values and On Hold does not show as one of the options to pick from.
  6. Remove the newly created filter for State and hit Run
  7. Click on the Closed Complete in the Donut graph that comes up
  8. Group the subsequent list view by the State field by right clicking next to State field and selecting Group BY
  9. This view shows records with On Hold as the state in the incident table along with some records with a state of Closed Complete
https://demonightlyjakarta.service-now.com/

Workaround

This is a common platform behavior on extended tables when grouping by overridable choice lists. There is no workaround.

Task is a parent table and state is a overridable choice list where extending tables can override choices. The Task State dictionary entry would have Incident state entries override it - so that On Hold in an Incident has the same numeric value Closed Complete in the task table. 



Related Problem: PRB635126

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.