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'.
If you found this article helpful please give a thumbs up below and if you found that there are things missing please leave a comment so that we can update the article
3767 Ranchero Drive, Suite 100 | Ann Arbor, MI 48108 | Toll Free 866.930.4774 | Fax 734.205.1011