To report on Events within Analytics, you must use the Learning Platform data model (LP Platform Analytics).
Analytics allows administrators to report on attendance across all Events created in the Learning Platform. Reports can include:
- Event information (for example, event and session details)
- User information (such as custom user fields)
- Attendance status for each session
This enables reporting at both the individual attendee level and the overall session attendance level.
Example Event Attendance Report
A typical attendance report may include the following fields:
- Event Name
- Schedule Name
- Session Name
- Time in Session Start Date
- Time in Session End Date
- Time in Session Signup Creation Date
- User Full Name
- Session Attendance Status
These fields allow you to see which users registered for a session and what their attendance outcome was.
Attendance Status Options
When marking attendance for an Event session, four possible statuses can be recorded:
- Attended
- Approved Absence
- No Show
- Partially Attended
These statuses can be added to Analytics reports and used to filter results based on reporting requirements.
Adding Attendance Status to a Report
When the Session Attendance Status field is added to a report, some records may display N/A.
This occurs when:
- A session has not yet started, or
- A session has finished but attendance has not yet been recorded
You can use this information to identify sessions where attendance still needs to be marked.
Filtering by Attendance Status
Attendance Status can also be used as a filter within the report. For example, you may want to create a report showing all users who attended Events across the Learning Platform.
By applying a filter for Attended, the report will only display sessions where users have been marked with this status. Multiple statuses can also be selected in the filter if required.
Reporting Attendance at Scale
Analytics can also be used to report attendance at a session level without displaying user information. This is useful when you want to see total attendance counts per session.
The following fields should be added to the Rows section:
- Event Name
- Schedule Name
- Session Name
- Time in Session Start Date
- Time in Session End Date
- Time in Session Signup Creation Date
Adding Attendance Status
Once Session Attendance Status is added to your Pivot Table, each status will appear as a separate column.
You may also see an N/A column. This represents users who:
- Signed up for a session, but
- Have not yet had their attendance recorded
If required, the N/A status can be removed using either:
- A Widget filter, or
- A Dashboard filter
Counting Attendance by Status
To populate the Pivot Table with numerical values for each attendance status:
- Add Session Signup ID to the Values section of the widget.
- Set the aggregation to Count.
This will display the number of registrations associated with each attendance status for a session.
Verifying Attendance Data
You can verify the report results by comparing the values in Analytics with the attendance data recorded in the Event session.
For example:
Session Attendance may show:
- Attended: 5
- Partially Attended: 1
The same totals should appear in the Pivot Table report for that session.
If the corresponding Event in the Learning Platform is compared with this report, the following results will be displayed: