How to set static colors for donut report values

[chrish5]

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,

[Hemanth M]

Hi @chrish5 ,

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

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

Hope this helps.

[AndersBGS · Accepted solution]

Hi @chrish5 ,

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

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

best regards

Anders 

[chrish5]

Exactly what I was looking for!   Thanks!