Is there a way to change data labels and legends in a servicenow pie chart report

[srinishrawoor]

I am trying a have a pie-chart report on a servicenow dashboard[UTAH].
Pie-chart is based on a instance table, consisting of Boolean column named Active with values: true or false.
Here in the pie-chart has group-by on Active(Boolean) column. We are trying to show, percentage or count of number of active profile on Pie-chart. But as you can see from the screenshot here, the legends are based on column-values and even the data-labels too.

Is there a way to modify these legends and labels to a alternative text, so that the pie chart labels show meaning data to management rather than showing true/false values. Something like this

PS:

1. altering the column to string values of ACTIVE/INACTIVE is cumbersome change, since this column's boolean value is heavily used in scripts and java-side code too.

2. altering instance table by adding another column(with string values of ACTIVE/INACTIVE), which is populated based on boolean values of this column, requires adding a script, which is an extra computation, everytime a row is updated in column. Also requires lot of approvals just to add dummy column, mentioned here.
3. Database views, couldn't understand how they could be used here, any insight or help in altering label values is helpful here.

[AndersBGS · Accepted solution]

Hi @srinishrawoor ,

Besides the options that you have mentioned by yourself in option 1 and 2, there is no other way to alter the labels. 

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

best regards

Anders

[Eswar Chappa]

Hi @srinishrawoor 

No, if you are grouping by a field which has true/false as the values in that field you will not be able to change labels in the legend. They are directly coming from the filter.

Thanks & Regards,

Eswar Chappa

Mark my answer correct and Helpful if this helps you 😀