How to Rename the count of the report.

[SivaprasadV]

Hello Community,

I have created a pivot report in ServiceNow that displays the count of records assigned to users. Currently, the report shows the default count values (as shown in the screenshot). When a record is assigned, it displays the count, and when no records are assigned, it shows 0.

I would like to customize these labels:

• Replace 0 with "Not Applicable"
• Replace "Count" with "Assigned"

Is it possible to rename or modify these values in the report?

Thanks in advance.

Can we rename the count..?  TIA.

[Tanushree Maiti]

Hi @SivaprasadV 

For replacing Count by Assigned, 

Refer:

KB0723527 Change a label for a report without changing the label for the underlying table 

Alias Table Column Headers/Values in Report? 

https://www.servicenow.com/community/spm-forum/is-it-possible-to-change-column-labels-in-reporting/m...

[vaishali231]

Hey @SivaprasadV 

Yes, it is possible to customize certain report labels using Report Label Aliases. This feature allows administrators to create aliases for report column headers and field values. However, it has some limitations, especially with Pivot Reports.

For example:

A column label such as Assignment Group can be displayed as Working Group.

A field value such as FlagForReview can be displayed as Needs Review.

However, for your specific requirements:

Renaming "Count" to "Assigned"

In a Pivot Report, Count is the aggregation function generated by the reporting engine, not a report field label.

Report Label Aliases apply to field labels and field values, not aggregation functions.

Therefore, renaming Count to Assigned is not supported out of the box.

Replacing "0" with "Not Applicable"

Pivot Reports display numeric aggregation results.

Since 0 is a valid numeric value, it cannot be replaced with custom text such as "Not Applicable" through standard report configuration.

This would require a custom solution, such as a custom dashboard widget, UI Builder component, or Performance Analytics visualization.

Report Label Aliases

If the feature is available in your instance, you can use Configure Report Labels to define aliases for supported report column headers and field values.

Depending on your ServiceNow release, this feature may need to be enabled through the appropriate system property.

So, while Report Label Aliases can be used to customize column headers and field values, they do not apply to Pivot Report aggregation labels or numeric aggregation results.

*************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.

Doing so helps others in the community and encourages me to keep contributing.

Regards

Vaishali Singh

Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb

[Ankur Bawiskar]

@SivaprasadV 

if this is for classic reporting module then that's not possible

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[SivaprasadV]

Hi @Ankur Bawiskar  / @Tanushree Maiti / @vaishali231 

Thanks for your suggestions 🙂. @Ankur Bawiskar I've created this report from classic report only but I've migrated the dashboard to PA. 

@vaishali231  As you mentioned it the not the field values. since I've used the pivot table it is aggregating the count. can you please let me know which property needs to be enabled to rename the count..? Thanks in Advance..

Regards

Sivaprasadnaik Vadithe