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 ?

4 REPLIES 4

PrashantLearnIT
Giga Sage

Hi @pramn 

 

We cannot do group by for List type field.

********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************

Hi @pramn 

Please mark the answer as correct if it helped you.

********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@pramn 

group by is not allowed on list field.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Sarthak Kashyap
Mega Sage

Hi @pramn ,

 

It is not possible on List type of field, please check the below screenshot

 

SarthakKashyap_0-1763459029584.png

 

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak