- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2019 11:08 AM
We have a custom application built. A user wants to group by a specific field in a pie chart from the table selected. That field is on that table and not on a referenced table. The field does not appear in the 'Group by' select BUT appears in the 'additional group by' option.
She wants to export the report grouped by that field but since it is in the additional group by, ServiceNow does not have the ability to export in the 'additional group by', only via a JPG/PNG and those cut off some of the information.
Any ideas on why that field only appears in the 'Additional group by'?
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2019 05:23 AM
So for example when you have a list field. there is an untold number of possibilities what can appear in that filed. It will most likely never be the same. Say you have it pointing to the user table like the watch list. One ticket could have user a, b, c, d, e, f, g, h and another ticket could have user a, b and then another ticket could have user x, y, z. Hopefully you are getting the picture. Group by is meant for things that can be consistent like the caller filed because you will only ever have one caller in that field for each record. Then string fields like short description can also have an untold number of different characters. Hope this helped.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2019 11:22 AM
The system does not allow Group By on fields with infinite possibilities (e.g., strings and numbers), you can only group by choices and references. This is designed to protect against performance issues. I believe it is a bug that allows those fields in the Addition Group By.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2019 11:23 AM
What type of field is it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2019 11:33 AM
Its a List field type
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2019 12:31 PM
That is one of the fields that you cannot group by because it has infinite possibilities as Adam mentioned. Per his comment it appears in the additional group by field because of a bug but will most likely not work as an additional group by. You can only group by Choice, reference, and Number (only when it is a system generated number such as Incident Number).
