Involvements

Meetings / Attendance (date range)¶

For this report, you specify a date or a date range. The report lists every meeting for every Involvement that is included in your filtered list. If you do not use any filters, you will get a report for all of your Involvements that have meetings during the date range.

There are 2 versions of this report and both are accessed from Blue Toolbar > Cloud when you are on the Involvements > Search page.

Excel Export: Opens directly in Excel or Numbers
Report: Opens in your browser

Run the Report¶

Step 1: Use the filters to get a list of Involvements to include in the report.
Step 2: From Blue Toolbar > Cloud, select Meetings/Attendance > Meetings/Attendance (date range) for the Excel/Numbers version, or Reports > Meetings/Attendance (date range) for the onscreen Report version.
Step 3: Select the date range using the calendar. Click Run.

Tip

If you want the report for a single date, select only a start date.

Here’s what the Report looks like when run for a date range. Notice that the report is sorted by the Involvement name, with one row for each meeting for each class during the date range, and with the meetings sorted by the most recent date.

The Excel/Numbers export contains the same information. It opens in Excel instead of in your browser.

../_images/AttendanceDetail-Report.png — Report¶

Tip

If you select the Excel Export, you can use Excel’s Subtotal feature to get the average attendance by class.

Here’s how to use Excel Subtotal:

Step 1: Delete the Total row at the bottom of the export. Otherwise, Excel will include it in the averages.
Step 2: Click any cell in the data. Then click the Data tab in Excel and select Subtotal.
Step 3: Select the settings as follows:

- At each change in Involvement

- Use Function Average

- Add subtotal to Present

- Click OK

Subtotal¶

This will put 3 summary buttons on the left of the spreadsheet:

Click 1 to see only the Grand Average
Click 2 to see the average for each Involvement
Click 3 to see all Involvements and all Meetings

Note

Your version of Excel may be different than the one used for the screenshot. If so, use the Help tab in Excel to find out more about creating Subtotals.