Avg Monthly Attendance for Org Report

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:

2016-08-09_17-23-38

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s