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.

[Kalaiarasan Pus]

Do a group by on 'incident_caused_by' column to get the total unique changes that caused the incidents.

[ryanlitwiller]

Thanks for your response Kalai, your referring from the incident table correct? This wont give me the total number of change requests though. I need:

(Changes that caused incidents / Total number of change requests) = % of change requests that caused incidents

I'm not sure if the group by solution will give me that unless I'm missing something?

[Kalaiarasan Pus]

Group by will give you this 'Changes that caused incidents '. You can get the Total number of change requests by querying change table directly.

[ryanlitwiller]

True, but I'm hoping to accomplish this within a report.