.. done

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.

.. figure:: images/AttendanceDetail-Report.png
    :target: #

    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`

    .. figure:: images/AttendanceDetail-Subtotal.png
        :target: #

        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.

.. seealso::
    :doc:`OrgSearch_Index`

|
|

+--------------------+------------------+
| **Latest Update**  | **10/23/2026**   |
+--------------------+------------------+

Updated the Involvements > Search path and Involvement terminology, replaced the sample report screenshot, and updated the Excel Subtotal steps and screenshot to match the current export columns.