Time series report group by field showing empty

[Dale Cameron]

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

[SanjivMeher]

I can't think of any reason. Must be a servicenow bug. Last thing to check, if each choice has a display value or not. If it has, next option would be to raise a HI ticket.

[Dale Cameron]

Ok Thanks, I'll open a HI Ticket. Below is a screenshot of the choices.

[Dale Cameron]

I found KB0598290 which says this issue was fixed in patch 5, but it looks like it may still be an issue for the time series reports. I opened a HI ticket, hopefully they will have a fix soon. 

[Dale Cameron · Accepted solution]

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.