To report on Events within Analytics, you must use the Learning Platform data model (LP Platform Analytics).
Reporting on Rooms within Events allows administrators and analysts to understand how Rooms are being used across the Learning Platform (LXP). By leveraging Analytics, you can:
- Identify the most frequently used rooms
- Validate that room information is complete and accurate
- Understand which events and sessions are using specific rooms
- Monitor room availability and usage trends
This guide will help explain how to create common room reports using Analytics widgets such as Pivot Tables, Tables, and Pie Charts.
Prerequisites: To report on Events data within Analytics, you must use the LP Platform Analytics (Learning Platform data model). This data model contains the required fields for Events, Sessions, Schedules, and Rooms.
Viewing All Event Rooms
A Pivot Table can be used to display all rooms configured in Events along with their associated details. This allows administrators to quickly confirm that all necessary information has been populated.
Example Use Case
Use this report to verify that rooms contain accurate booking information before users schedule sessions.
How to Build the Report
- Create a new Pivot Table widget, then
- Add Room Name as the first field (this identifies each room in the report).
- Add additional room information fields as required.
Available Room Fields
The following fields can be included in the report:
- Room Name
- Room Description
- Room Capacity
- Room Location
- Region
- Postcode
- Country
- City
- Address 1
- Address 2
Only fields that contain data within the Events configuration will display values in the report. The report will display a list of all available rooms and their associated details, enabling quick validation of room configuration.
(Example below on available data to add within the LXP)
Identifying the Most Used Rooms
A Pie Chart widget can be used to visualise which rooms are used most frequently for sessions.
How to Build the Widget
- Create a new widget.
- Select Pie Chart as the widget type.
Configure the Data Fields
Categories
- Add Room Name (this will display each room as a slice of the pie chart)
The Pie Chart will then display, the percentage of sessions per room and the total number of sessions when hovering over a slice. You can also rename the value label (for example, from # of Session ID to Number of Sessions) for better readability.
Optional, but you might want to consider improving report accuracy, by removing any test rooms, exclude N/A values or filter out deleted events. Deleted events can be removed by filtering out deleted resources.
Value
- Add Session ID
- Change the agregation to Count All (This counts the total number of sessions using each room).
Important to note - Using Count All ensures Analytics counts every session assigned to the room, rather than just a single occurrence.
It is also possible to alter the value text title from '# of Session Id' to something more meaningful.
Optional Configuration
You may also want to:
- Adjust how many slices appear before grouping into "Other"
- Modify chart colours to match reporting preferences
Reporting Which Events Use Each Room
Analytics can also display which Events and Sessions are scheduled within each Room.
This report is useful for, understanding room allocation, auditing event scheduling or reviewing session-level usage. You can use the Pivot table widget to display this information.
(Sample report)
How to Build the Report
Create a new Pivot Table and add the following fields in Rows:
- Session ID - Ensures duplicate session names are displayed
- Room Name - Groups sessions by room
- Schedule Name - Maintains the event schedule structure
- Session Name - Identifies the session
Analytics does not automatically display duplicate names. Adding Session ID ensures sessions with the same name appear individually.
If you want Session Name to repeat for each Session ID, move Session ID above Session Name in the row order. This forces the session name to repeat for each unique session.
Using a Table Instead of a Pivot Table
If you prefer a simpler report layout, you can convert the widget to a Table. In this format;
- Room Name will repeat for each session using that room
- Each row represents a single session instance
Sorting the Table
Tables do not automatically sort alphabetically. To sort the report:
- Locate the field Event Room Name
- Apply Alphabetical (A–Z) sorting
This will organise the report by room name.
Additional Reporting Options
You can expand these reports further by including additional session details, such as:
- Session Start Time
- Session End Time
These fields allow deeper analysis of room scheduling and utilisation.
Summary
Using Analytics, you can create several useful reports for Event Rooms:
Pivot Table (Rooms Overview) - To validate room configuration
Pie Chart - Helps identify most-used rooms
Pivot Table (Event Usage) - Allows you to see which events use each room
Table - Allows you to view sessions per room in a flat list
These reports help administrators maintain accurate room data and better understand how learning spaces are used across Events.