How to create dashboard which show the percentage?

Ankit Kumar6
Tera Contributor

‎08-06-2024 11:52 PM

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
 
 
0 Helpfuls
  • 303 Views
1 REPLY 1

Ankit Kumar6
Tera Contributor
In response to esther598

‎08-07-2024 12:29 AM

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

0 Helpfuls