Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Group By count is not matching total record counts

RahulY00040
Tera Contributor

Hello friends,

 

Today i noticed that when I did the group by against the filtered CIs listing using field Discovery Source. What I noticed that discovery source grouping count mentioned in parenthesis is not matching against the total records count when added together. THis is not happening for every field, but noticed for the field Discovery Source.

 

**I can not share screenshot here.

 

Anyone has any idea, thanks in advance

Rahul

 

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

I would look for records with an invalid Discovery Source.  Since this is a field with choices, if the value stored in the field doesn't match the value of a choice record, it could have trouble grouping on that value.