Reports

[AbidJafrey]

Hi,

In a report i need to set the colors for the state in stacked by, but im not getting where can i edit to change the colors. Can someone help me out with how can i edit this.

[G Ponsekar]

Hi @AbidJafrey ,

To edit the colors for states in a stacked bar report in ServiceNow, you must use the Chart Colors configuration. This is a special table that allows you to define specific colors for different values of a field, which will be applied to all reports using that table. 

Please refer article - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0753079#:~:text=Issue,changed....

How to set up custom chart colors

1. Navigate to Chart Colors:
   • In the Filter Navigator, type sys_report_chart_color.list and press Enter.
   • Alternatively, you can go to Reports > Chart Colors.
2. Create a new Chart Color record: Click the New button to create a record that will specify the color for a particular state.
3. Fill out the Chart Colors form:
   • Table: Select the table your report is based on (e.g., Incident, sc_req_item).
   • Element: Select the field you are using for the stacked grouping. In your case, this is the State field.
   • Value: Enter the exact value of the state you want to color (e.g., Open, In Progress, Closed).
   • Color: Use the color picker to select the desired color, or enter a hex color code (e.g., #FF402C for red).
4. Repeat for all states: Create a new record for each state value you want to assign a custom color to.
5. Run the report: After saving the Chart Colors records, run your report. The stacked bars will now display the custom colors you defined for each state

Report-specific colors (manual hex codes)

For a single, ad-hoc report, you can define the colors directly on the report configuration page.

1. Open your report: Navigate to Reports > View / Run and open the report you want to modify.
2. Go to the Style tab: In the report designer, click on the Style tab.
3. Select a Chart Color option: Under the General sub-tab, find the "Chart color" field and choose one of the following options:
   • Several colors: This will display a text box where you can manually enter comma-separated hex codes (e.g., #FF0000,#00FF00,#0000FF). The colors are applied to the states in the same order they appear on the chart.
   • Fixed element color: If you have already defined Chart Colors (as described in the main solution), this option will apply those colors.
4. Run and save: Click Run to see the changes. If you are satisfied, click Save to save the report with the new colors.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[OlaN]

Hi,

If I understand your query correctly this cannot be done with OOB reports.

Sure, you can change the coloring scheme set by the report as explained by G Ponsekar,

but you cannot actually set that "the value new should always be blue".

And this is because you dont know which value will be the largest in the report.

As per my understanding the coloring always sets the colors according to the values. (most common value = first color and so on)

You might need to look into some plugins such as Vivid charts or others that has much more flexibility in regards to reporting.