Reporting on Company table

[Daisy3]

Hi,

I am looking for some idea to report on the core_company table that displays the total number of companies, vendors and manufacturers. Can this all be achieved on a single report.

Additionally, the "Vendor" & "Manufacturer" fields are True/False fields and hence using Donut (Group by Vendor/Manufacturer) shows true/false as Labels. If there is a better way to display the Labels as Vendors and Manufacturers instead of True/False it will be helpful.

[AndersBGS]

Hi @Daisy3 ,

Why not just create some different single score report where the condition is stating that manufacturer is true etc.

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

Best regards

Anders 

[Robbie]

Hi @Daisy3,

As you have experienced Reports are based on the underlying data points, which in most cases works perfectly. Sadly however, in a use case similar to yours, it doesn't.

As @Tai Vu and @AndersBGS have suggested - which are great options, you can simply change the report type to provide the data you want.

Sadly, there is no way to directly override the labels easily unfortunately, however I have seen this possible by creating a Database view for the table.

This is not ideal, however it does work. (Consider the long term use and maintenance of the report - for example if another developer comes and has to review or update it... make sure there some sort of note or documentation regarding it if you decide to go down the DB View path)

Check the similar question in the community with steps:

https://www.servicenow.com/community/developer-forum/how-to-rename-field-labels-for-reports-only/td-...

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Tai Vu · Accepted solution]

Hi @Daisy3 

If you're looking to display multiple elements with different conditions in a single chart, you can leverage the Dataset feature in reports.

However, you won't be able to create a Pie chart exactly like the one in your screenshot.

On the other hand, you could consider using separate Single Score reports as Anders suggested. It's more straightforward and easier to configure.

Cheers,

Tai Vu