RCA Report

[rc393g]

Hi All, we are working on the reporting for Problem Management and would like to know your thoughts on the best way to show Number of Incidents per problem with RCA vs All Incident. Thank you.

[rob_blakey]

Hi rc393g,

This really depends on what you are trying to view and how. From my perspective, if you have a field on your problem management form for documenting root cause, then you could run a report to see the number of Incidents per associated problem.

The way I achieved this is by creating a Report like this:

This shows me a report that lists all Problem Record ID's and the total count of Incidents per priority. From that you could add a filter condition to only show Problems where Root Cause is empty.

[Deepak Ingale1]

Kindly do reporting on incident table.

Filter should be like

problem_id should not be empty

Then you group incidents by 'problem_id' field.

[rc393g]

Thank you for your response! I learned that this report should be done under Incident table.

Hi Rob -- I tried to do similar to your screenshots and it is a good start for me.

Hi Deepak -- Will this be for list or what report type do you suggest?

Now, will have to work more showing the number of Incident with RCA versus the number of all incidents.

[Deepak Ingale1]

Good to know that it helped you

I guess it will work for both list as well as bar.

For comparing, since both are exclusive so you should pull them up separately in two files and will have to compare by means of some charts in excel.