how to create a report to display the count of null vs not null in the fields for a table?

[Deepika Govinda]

We have a requirement to run a report on the server table and to show the count of null vs not null for a field in a Bar graph

[ChrisSteinke1]

Hi Deepika. This already exists out of the box as part of the CMDB Health Check feature. Before you head down the road of creating a complex custom report, it could save you time and effort to use the existing feature.

Making it mandatory for CMDB Health Check is a little different than updating the Dictionary. Here is a link to info on configuring mandatory fields in the CMDB:

https://docs.servicenow.com/bundle/kingston-servicenow-platform/page/product/configuration-management/task/t_SetCIFieldMandatory.html

Regards,

Chris

[sachin_namjoshi]

You will have to use performance analytics for this requirement.

you will have to configure formula indicators and then configure breakdowns to show count of null vs not nulll for field in bar.

Please check below to get you started

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/performance-analytics/reference/r_PALandingPage.html

Regards,

Sachin

[MohammedAsK]

I have the same requirement, exactly same for CMDB. To show for recommended fields the count of records which are missing the data.

Unable to find the solution.