Overview & When to Use

This report provides a cross-tabulated view of daily attendance counts by site, making it easy to spot trends, gaps, and spikes in participation across the program calendar. It is designed for program coordinators, site administrators, and others who need to monitor participation patterns over time.

• Use this report when reviewing how consistently participants are attending at each site across the program year.
• Use this report when identifying dates with unusually high or low attendance that may warrant follow-up

How to Read the Report

• Start with the site rows — each row represents a distinct site, so you can immediately see which sites are active (defined by having any people in the current term) and which have gaps on any given date.
• Scan across the date columns — each column represents a specific date when at least one attendance was recorded by any site displayed on the report; cells show the attendee count for that site on that day.
• Look for zeros or blank cells — these indicate dates when a site had no recorded attendance, which may reflect a cancelled session, a data entry gap, or a site that was not open on that date.

Key Metrics

Statuses, Colors, and Alerts

• Zero (0) values — displayed as plain zeros; no distinct color or alert is applied, but these should be reviewed to determine whether a session was scheduled but unattended or simply not held.
• No other color codes, status flags, or alert indicators are used in the report.

Notes, Limitations, and Related Reports

• The report displays only dates which have at least one attendance recorded; dates with no attendance across all displayed sites do not appear as columns.
• Sites with no attendance on a given date show a count of 0, but the report does not distinguish between a with zero attendance and a date when the site was not open.
• The grain of this report is site-level by date — it does not break down attendance by individual student, activity, or session within a date.

Report Filters

The following filters are available for this report:

• Date: Restricts the report to session dates within a specified date range. Use this to focus on a particular program period, month, or quarter. Both a start and end date can be set.
• Site: Restricts the report to the site selected. Use this to focus on site attendance for a particular site. Note if the site filer is sued, the activity and session lists in the next filters will be limited to the activities/session from that site.
• Activity: Filters the attendance data to one or more specific activities. Use this when you want to see attendance for a particular activity or activities offering rather than all activities combined. Only the sites that have the exact Activity name will be displayed.
• Session: Narrows results to one or more specific sessions. This is useful when a site runs multiple sessions and you want to isolate attendance for a single one.
• AM/PM: Filters by the time-of-day designation of the session (AM or PM). Use this when your program runs both morning and afternoon sessions and you want to compare or isolate one; this AM/PM is based on the session start time.

To apply filters (not available for all reports), use the filter icon available at the top right of the report header. The filter options shown in this report are the same for all users.

To filter by additional fields that are not available on-screen, export the table to Excel, turn on filters for the header row (Data > Filter), and use Excel’s filter dropdowns. For a quick tutorial, see Microsoft’s “Filter data in a range or table” video on https://support.microsoft.com/.

Updated May 26, 2026 14:30