- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 10:51 AM
I am creating a report on the Incident table for some custom fields we have added. The problem I'm having is when I group by 'Unauthorized Change Resolution' (a choice type field with 5 possible values including none) they are coming up as empty even though all record have a value. You can see in the screenshot attached/below that in the table it is showing 3 groups for Feb and the count for each, this matches the data. The report knows the values are different and is grouping them appropriately, but since the field value is also coming through as empty the report is unable to display correctly. If I change the report type to anything other than a time series report then the data displays correctly, but then it is not grouped by month.
I have checked ACLs and the fact that it works with other report types makes me think it is not a security problem, but a bug of some sort in the time series reports.
I have also attached a screenshot of the regular bar chart so that you can see that the data comes through correctly.
thoughts?
Time Series Screenshot
Normal Bar Chart Screenshot
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2018 10:26 AM
This issue is fixed in Kingston, but in the mean time I remade the field with a name (not label) less than 30 characters long.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 10:59 AM
The Grouping also doesn't show on the bars in your report. Can you switch to classic view and try it? Also try grouping by other field and check if that works.
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 11:08 AM
Thanks for the reply,
I have tried both of these. The Classic view gave me the same result with Unauthorized Resolution field.
I tried assignment group and the state and both worked just fine in the time series report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 11:45 AM
Not sure. Is there a record with some value in that field which is not in the defined Choice List?
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 12:00 PM
There are only 10 records that meet the critiria(in Dev), so I checked all of them and they all have a valid value in the choice list.