Meeting Attendance Report
This report is lists every meeting for every organization that is included in your search.
From the Org Search page -
- Filter for a Program and Division and/or Schedule (example: Life Groups, Median 1, Sunday 8:00 AM)
- Click the Meetings Attendance link at the bottom of the page
- Enter the date range...if you want the report for a single date, just enter a start date
- Click Run
Here's what the report looks like when run for a date range. Notice that the report is sorted by the Organization name, with one row for each meeting for each class during the date range, with the meetings sorted by the most recent date.
If you generate the report for a range of dates as above, you might want to copy and paste the report into Excel and then be able to view averages for each class, etc.
Here's how to do that:
- Drag your cursor over the entire table, making sure to include the headers but exclude the totals
- Press CtrlC to copy
- Open Excel and press CrtlV to paste
- Make one column wide enough to see all the text, then highlight all the columns & then double click on the outer side of the last column to expand all the columns
- Click on the Data tab in Excel & select Subtotal
- Note: This will allow you to get an average attendance for each organization
-
Change the following settings then click OK:
- Change at Leader
- Use Function Average
- Add subtotal to Present
-
This will put 3 summary buttons on the left of the spreadsheet
- Click 1 to see just the Grand Average
- Click 2 to see the summary averages
- Click 3 to see all organizations and all meetings
- Here's what it looks like total expanded (all organizations and meetings)
- Here's what it look like when you click 2 to see only the classes and the average:
-
