Percentage of change requests that caused incidents

[ryanlitwiller]

I'm looking for the capability to see all change_requests and know what percentage caused incidents. I know I can snag caused_by from the incident table but that seems to being going the opposite way that I need.

I was thinking that I would need to create a database view where change_request_sys_id = incident_caused_by. This seemed to work to get all the incidents caused by changes but then I still don't have access to the total number of changes to get my percentage. I thought I could accomplish this by setting up a left join on my database view, but now I'm getting no results.

Open to any suggestions on a solution whether its a DV or not.

[siva_dirisala]

Hello Ryan, if you are using Performance Analytics, it's easy to do this using a formula indicator, see Create a formula indicator

[ryanlitwiller]

Only have trial version of performance analytics

[jmoore]

Hi Ryan,

Did you figure this one out? I think I was able to create a database view, but am having trouble generating a report within ServiceNow that will produce a %.

Thanks!
Jessica