Reports pie charts colors

[jarretjo]

Hi,

I have created a Pie Chart Report based on table pm_project_task ->  Group by:Overall health -> Aggregation:Count.

If I select any of the 3 values in the field "Chart color" and leave the field "Color" empty then I get a nice pie chart with 3 colors Green, Red and Yellow.

Where do these default colors come from?

sys_properties= com.snc.pa.chart_default_color_schema= Default UI14 which has 32 colors defined

[Community Alums]

Hi @jarretjo ,

Table : pa_chart_color_schemes

This table have different colour definition. Here, we can create our own definition also.

In the report style tab we need to select Chart color : use color palette

Also we have use different colour by selecting Hex code after Chart color : use several color.

Please mark answer helpful and accept it as solution

Thanks 

Akash

[jarretjo]

Hi Akash, Thanks I got all that. The 3 options and creating own definitions. 

Also Hex codes.

But my question is if you leave the Field "Colors" blank after selecting any of those 3 options, where does it get the colors from?

Thanks

Joe

[Community Alums]

Hi @jarretjo 

In Reports > Administration > Properties - default colour is defined.

Doc : https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/reference/reporti...

Please mark answer helpful and accept it as solution

Thanks 

Akash

[jarretjo]

Hi Akash, Looks like it could be getting closer, but not there yet!

Here is the sys_property for:

glide.ui.report.datasets.default_colors=

Default Color, UI14 Green, UI14 Orange, UI14 Chart 02, UI14 Yellow, UI14 Purple, UI14 Red

Thing is I have moved these colors in the Sys Property around, even removed them completely. Still the pie chart comes up as below! And the sequence of the default colors doesnt really explain the colors that appear in the pie chart.

The only other property it might be is:

glide.ui.report.datasets.default_palettes=

Default UI14, Blues light to dark (5), Greens dark to light (5), Oranges light to dark (5)

which doesnt look close!

Any other tips?

Thanks 

Joe