Time series report group by field showing empty

Dale Cameron
Giga Contributor

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

find_real_file.png

 

Normal Bar Chart Screenshot

find_real_file.png

1 ACCEPTED SOLUTION

Dale Cameron
Giga Contributor

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.

View solution in original post

8 REPLIES 8

SanjivMeher
Kilo Patron
Kilo Patron

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.

Dale Cameron
Giga Contributor

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

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.

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.