How to create a report for a count of the number of parents table records which have conditions based on the child table records?

[Brian Hewey]

I'm trying to create a dashboard report for the GRC audit module where it will display the number of engagements which have observations within them when the observation is priority of minor or recommendation only.  I want to exclude the engagement if it has critical or high observations.  

I can get the records I want in a list by setting conditions as needed but then to see the count I basically have to group by engagement and then look at the count of groups.  I'm looking for a count report that basically will give me that same count but just a a single number for a dashboard.

[JP - Kyndryl · Accepted solution]

Hi Brian,

Here's how this can be done (see attachment).

Add your criteria for filtering.

Regards.

JP