How to build a query to report all registered families per organization
Below is an image of a query that will return all registered families based on organization information. This will give the count of all registered families that are at the selected organization with Organization ID, Organization Name and City of the Organization.
As the example shows, you may rename the columns on the right-hand side in order for the results columns to read easier. To get the correct results, you will need to do a 'count' of the family DUID. If you do a 'Sum,' it will add together each family DUID; so do a 'Count' and not a 'Sum'.