How to enable a custom field to be available in reporting as a Group by

[Adam Robbins1]

Hi,

I am wondering if anything special is needed to enable a custom field to be available as a Group by in reporting.

I created 2 custom fields on the Incident table.  1 that concatenates the Category and Subcategory and another that concatenates 2 other custom fields for a Cause category and Cause subcategory.  The first one is available as a Group by while the 2nd one is not.

Here are some screenshots:

Custom field that is available as a Group by:

Custom field that is NOT available as a Group by

Thanks,

Adam Robbins

CORRECT ANSWER: (ServiceNow does not allow me to mark my own reply as a correct answer, so I'm pasting it here)

I got it working now.  I went back into the Dictionary and temporarily adjusted the Type from String to Choice and then Saved.  Then I adjusted back to String and saved again.  Now it has the Group by option.  I am not sure why that worked though.

Thank you,

Adam Robbins

[Adam Robbins1]

I got it working now.  I went back into the Dictionary and temporarily adjusted the Type from String to Choice and then Saved.  Then I adjusted back to String and saved again.  Now it has the Group by option.  I am not sure why that worked though.

Thank you,

Adam Robbins

[JR42]

Thanks, this did the trick.

[Adam Robbins1]

I also can't find where to mark this post as solved.  If anyone knows how to do that, let me know

[Rohit Kaintura]

You have to mark answer correct.