I want to find the number of repeated incidents in a given time period. These repeated incidents are not major incidents for us. I have tried creating a query on incident object. What I would like to check is whether the incident has a child associated with it. If yes, then display that incident only in the query results.
you could check in the Incident object, if the "Children"-Collection isn´t null.
So you know, that there child incidents associated with the Incident.
Unfortunately I am not able to drag children collection on to the criteria selection.
You could create a calculated boolean attribute that is set to true if there is a child added to the incident.
Then use that as your criteria.