How to Change System Default for Chart 'Max number of groups'

[Mike Turner]

Hi,

Can anyone help identify a method to change the value associated to the 'system default' of the report "Max number of groups parameter"? - this parameter controls how many bars would be shown in a bar report before the 'Other' bar is shown.

The system default seems to be set to a value of 12. We would like to be able to change this system default and all reports rather than going to individual reports and hardcoding a value. This way, our settings are dynamic and uniform .

I have already seen the values stored in sys_choice that associate 'system default' to a choice value of -2 as well as how I would add a new value to the sys_choice table.

Is there a setting that controls what the system default is? - I was hoping to find it as one of the reporting properties but nothing is jumping out at me.

Many thanks

Mike

[JP - Kyndryl]

Hi Mike,

After some research I was not able to find out where the Default value of 12 was maintained.

This said, you may well modify all the Bar reports via the   Reports > Admistration > All .

Filter on the Bar type and make sure you add the following 2 fields in the list:

Other threshold,  Others

Use right mouse on the titles and select Configure > List Control  in order to activate the List edit type (that is inactive OOTB).

You may then update the Other threshold and Others columns from the list.

Regards.

JP

[JonathanGreer]

Thanks this worked.

[Tsura Andreeva]

I read that the choice table is where you could add more values:

https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/localization/refer...

[kb-h]

I found this useful to add choices to the max number of groups
Add custom choices in "Max number of groups" - ServiceNow Community