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

keithbergen · ‎06-02-2022

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 · ‎06-03-2022

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 🙂

View solution in original post

keithbergen · ‎06-03-2022

Thanks. I found that this morning ... stumbled across it really.

Our Problem Statement field is labeled "Short Description". I don't know if an administrator has renamed it (I doubt that). I don't see a "Problem Statement" field on our Problem screen.

keithbergen · ‎06-03-2022

Ok. So after a couple years of pondering this issue, I finally posted this question. The next day I found the "Related Incidents" field which shows (you guessed it) the number of related incidents attached to the Problem. I don't know if that is new or if it was recently added, but it works great!

Community Alums · ‎06-03-2022

Hello Keith,

Glad to know that your issue is resolved. Have a great day and weekend ahead 🙂

Regards,

Akshay Kangankar