question Re: How to create dashboard which show the percentage? in Developer forum

How to create dashboard which show the percentage?

Ankit Kumar6 — Wed, 07 Aug 2024 06:52:20 GMT

Hi Folks,

how can I create a dashboard in service now where i have to show the percentage of IP uploaded in custom table in service now and compare the IP in custom table with the total IP in CMDB table and show the percentage in dashboard.

and there is multiple duplicate eateries of IP in custom table.

How can i achieve this please help me.

Thanks

Re: How to create dashboard which show the percentage?

Ankit Kumar6 — Wed, 07 Aug 2024 07:29:17 GMT

Hi @esther598

can you help me with this:

Create a new Database View that joins the custom table and the CMDB table on the IP address.
Use the Database View to create a new report that calculates the percentage of IPs in the custom table compared to the CMDB table.

Thanks

Ankit