We blogged about this SQL recipe last year, but we recently made a change to the recipe. It now includes the Program and Division in addition to the name and ID# of each organization. Of course, it also displays the total number of attends (how many attendances were recorded for all the meetings), the total number of meetings, and the average attendance for those meetings.
If you remember, you can run this from the blue Toolbar on Organization Search, and you supply the date range. So, you can run it for a month, a quarter, a year – whatever you want. And because it is on the Toolbar on Organization Search, you can filter for whatever groups of organizations you want.
Here is a sample report:
Interested in this recipe? Or perhaps you want to update the recipe in your database if you added the original version. Then check it out below. It’s so simple to add to your database.