How to make report where 1 incidents has 2 cases

[Alex D Great]

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?

[Mohith Devatte]

hello @AHN ,

what exactly means by double case ?

and are you creating a single score report ?

[Alex D Great]

Hi @Mohith Devatte 

With double case, I mean 1 incident has 2 cases (should only be 1 case, but a faulty BR auto created the second case)

Yes I am looking to create a single score report.

[Mohith Devatte]

@AHN i don't think you can find how many incidents have two cases under them in normal reporting .

It might be possible if you USE PA but it is way more medium level task and more effort just to get a count .

so i would suggest run a back ground script using glide aggregate where your condition can be like more that 2 count or just go to list view of cases and do group by the field where incident is stored.

Hope this helps 

thanks

[Abhijit4 · Accepted solution]

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