Why does custom fields not get added to Stacked By control in bar chart in Kingston

CharlesGriff
Mega Sage

‎03-08-2018 02:31 AM

In Kingston the stacked by field once the report is created and you add more fields to the group by drop down those fields are supposed to be added to the stacked by drop down also, but this is not the case if the field is a custom field. Has anyone come across a similar situation out there? If this is the case it is a bug in Kingston and needs to be fixed because it works in Istanbul I can add any field and it gets displayed in the stacked by drop down.

Thanks

Labels:
0 Helpfuls
  • 1,221 Views
4 REPLIES 4

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎03-08-2018 07:27 AM

What version did you upgrade from?  Is this a Report Builder vs. Report Designer issue?  I believe it may be related to field types, but not sure without a little more detail.

0 Helpfuls

CharlesGriff
Mega Sage
In response to Adam Stout

‎03-12-2018 01:56 AM

Hi Adam

We upgraded from Istanbul to Kingston and this is a report designer issue. The field type is a string field type and it happens in a clean Dev instance when I create a new field on the table it does not get included.

0 Helpfuls

CharlesGriff
Mega Sage

‎03-12-2018 02:20 AM

I missed the information in the documentation that stipulates the fields that are allowed to be stacked by in Kingston.

String fields are no longer allowed for some reason.

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/reporting/task/t_ConfigureAReportToDisplayInteractiveChoices.html

 

 

0 Helpfuls

Adam Stout
ServiceNow Employee
ServiceNow Employee
In response to CharlesGriff

‎03-12-2018 07:27 AM

That is it.  I believe since strings have infinite possibilities, it isn't allowed in this context.  If you convert this to a choice list, you should get what you are looking for.