How to create a Problem report with the number of Incidents?

[keithbergen]

I am creating a dashboard and one element of the dashboard is the Problem list and the number of incidents attached to each problem list. These are currently 2 reports. I would like to merge them, but am unsure how to do that. Basically I would like to create the report so that it lists:

Problem# - Short Description - #Incidents(count)

Thanks,

Keith.

[Community Alums]

Hello,

Create report on incident table. Then from configuration tab, choose the columns you needed. PFB screen shot.

Here, Number and Short Description are fields present on incident table, while Problem and Problem Statement present on Problem table. To get fields from problem table, click on problem (+) plus sign 1st then sign appeared between slush bucket. PFB screen shot -

Result - 

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[keithbergen]

Hi Akshay,

That is not quite the report that I'm looking for. Using your example, the report that I want to write would look like this:

Problem         Short description                                  Incident
PRB0001001   Unable to connecting to internet...              1
PRB0000011   Unknown source of SAP outage                   5

This would be very useful on our dashboard so that we can see all of out Problem tickets and the number of Incidents associated with them.

Thanks,
Keith.

[SumanthDosapati]

Hi @keithbergen 

You can try these steps:

1) Create a new 'Incident Count' field in problem table.

2) Write an insert & update business rule on Incident table to update value in newly created field.

3) Run a one time background script to update new field value in existing problem records.

4) Now create a report on problem table and use the new field in the columns.

Feel free to ask if you have any queries.

Mark as correct and helpful if it solved your query.

Regards,

Sumanth

[Community Alums · Accepted solution]

Hello Keith,

If you just want related incidents count, you will easily get it from "Related Incident" field which is already present on problem table. PFB screen shot.

I hope your short description column means "Problem Statement". 

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂