How to set static colors for donut report values

chrish5
Giga Guru

I have a custom table with 3 columns I am trying to report on with a custom color scheme I created.  For the first two columns (Pulled, Approved) I need Yes to always be green and No to always be red.  For the last one (Rejected) I need the opposite, No to always be green and Yes to always be red.  As I play around with these, it appears that the higher % is always green, so for any chart, Yes could be red when it's 28% and then it changes to green when it goes above 50%.  I need static Yes/No colors for each report/chart.   Is this possible?    

 

Thanks,

 

chrish5_0-1703102963679.png

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @chrish5 ,

 

Go to sys_report_chart_color and define the specific color for the specific value just as snipped below:

AndersBGS_0-1703141860529.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up,

 

best regards

Anders 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

3 REPLIES 3

Hemanth M1
Giga Sage
Giga Sage

Hi @chrish5 ,

 

You can create a new color palette and select the colors for your display as below

HemanthM1_0-1703132091166.png

 

go to reports>Char Color Schemes , create a color palette and apply on the report.

HemanthM1_1-1703132131344.png

 

Hope this helps.

 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

AndersBGS
Tera Patron
Tera Patron

Hi @chrish5 ,

 

Go to sys_report_chart_color and define the specific color for the specific value just as snipped below:

AndersBGS_0-1703141860529.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up,

 

best regards

Anders 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Exactly what I was looking for!   Thanks!