This is a new SQL recipe that your Admin can add to your database . The report will run for the current organization and will be for the life of the organization. The total attendance for the month, the number of meetings, and the average attendance will display in columns, sorting with the most recent at the top.

You can run this for an org that tracks individual attendance (Life Group) or for an org that tracks only a headcount (Worship).

This is a sample:

Remember, we have the SQL script in the help article. You just copy and paste it into your database. After you run the script, you can select Add Report to Menu (this is the main Reports menu in the header). You also have the option to open the report in Excel.

Read more...