How to make report where 1 incidents has 2 cases

Alex D Great · ‎09-06-2022

Hi all

I have created a number report where I identify incidents with no cases, but dont seem to get the double case report correctly.

I had some issues where incidents would open a second case related to it (supposed to be only one). So I wonder if anyone knows how I can make a number report on this to quickly identify if I left out any incidents with double case?

Abhijit4 · ‎09-06-2022

You can find out those cases just by going into Case list view and perform group by incident. It will show 2 count wherever there is incident with two cases.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Regards,
Abhijit
Community Rising Star 2022

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

ServiceNow Buddy Website LinkedIn

View solution in original post

Alex D Great · ‎09-06-2022

Thanks guys

I ended up using the case list with group by. I would prefer the number, but most important was to clean the list .

Thank you very much for the assistance 🙂