% of Incidents where the linked Configuration Item (CI) was not changed

[Mk_snow]

Hi,

I have a requirement to create a Data Visualization for the following KPI:
% of Incidents where the linked Configuration Item (CI) was not changed during the incident lifecycle.

For example, assume there are 1,000 closed incidents:
For 700 incidents, the linked Configuration Item (CI) remained the same from the time the incident was created until it was closed.
For the remaining 300 incidents, the Configuration Item (CI) was updated at least once before the incident was closed.
I would like to create a pie chart that displays:
CI Not Changed: 70%
CI Changed: 30%

Now the problem is we don't have license for platform analytics. 

Thanks in advance 🙂 

[Chetna_Aggarwal]

Since you don't have a Platform Analytics license, you won't be able to create a calculated KPI directly.

One alternative is to use Audit History (sys_audit) to determine whether the Configuration Item field was updated during the incident lifecycle.

You could:

• Create a scheduled job or script to identify closed incidents where the cmdb_ci field was modified at least once.
• Store the result (e.g., CI Changed = Yes/No) on the Incident record or in a custom table.
• Use a standard ServiceNow report (Pie Chart) to display the percentage of CI Changed vs CI Not Changed.

This approach works with the standard reporting capabilities and does not require a Platform Analytics license.