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.

Field is not available when we are grouping by

pramn
Kilo Sage

Hello team , 

We are in Process to Preparing Report, however there is a field called 

pramn_0-1763456589905.png

it is not showing when i am trying to do group by 

pramn_1-1763456774807.png

Why it is happening ?

Dictionary level 

pramn_2-1763457048034.png

Can you help me to resolve this ?

5 REPLIES 5

Me Being Mustaq
Tera Guru

Hi @pramn ,

 

It is not possible to use "Group By" on List type fields (fields that hold multiple values such as users or groups) in ServiceNow reports or list views. The platform restricts group by operations to single-value fields for stability and performance reasons, as each unique List field combination would create a separate group—making aggregation and summary unreliable.

 

You can find below articles on this 

If it is helpful, please hit the thumbs button and accept the correct solution by referring to this solution in the future it will be helpful to them.

 

 

Thanks & Regards,

Mohammed Mustaq Shaik