Color code using for report

[Sirisha24]

Hi , 

could you please help me with this scenario.

I need to create a donut chart report for a dashboard where each value category (e.g., Very Low, Low, Medium, High, Very High) is consistently represented by a specific color. The color assignments should remain fixed, and even if a category has no data, its color should not shift to represent another category. For example, if "Low" is assigned red and "Very Low" is assigned green, the absence of "Low" should not result in green being used for another value.

[Viraj Hudlikar]

Hello @Sirisha24 

Go through this Solved: How to set static colors for donut report values - ServiceNow Community

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Sirisha24]

Thanks for your reply .

When I use a palette or comma-separated color codes in reports, it works well if all value categories have tasks. However, if "Low" is assigned red, "Very Low" is pink, and "Medium" is blue, and there are no tasks for "Low," the color for "Very Low" incorrectly shifts to Red. This behavior should not occur, and the assigned colors for each category must remain fixed regardless of missing data.

[Juhi Poddar]

Hello @Sirisha24 

You need to define the colors for each value in the sys_report_chart_color table. Please refer to my detailed explanation above for step-by-step guidance.

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[Sirisha24]

It's still not working for me because I need to use the backend value for chart colors. However, the value I need to use comes from a  field of string type. How can I handle this scenario?