Events Room reporting within Analytics

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 

  1. Create a new Pivot Table widget, then
  2. Add Room Name as the first field (this identifies each room in the report).
  3. Add additional room information fields as required.
Room - Adding room name 3.0.gif

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
Screenshot 2026-02-25 090848.png

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)

Screenshot 2026-02-24 132545.png

Identifying the Most Used Rooms

A Pie Chart widget can be used to visualise which rooms are used most frequently for sessions. 

Screenshot 2026-02-24 103935.png

How to Build the Widget

  • Create a new widget.
  • Select Pie Chart as the widget type.
Room - Selecting Pie Chart.gif

Configure the Data Fields

Categories

  • Add Room Name (this will display each room as a slice of the pie chart)
Room - Selecting Room Name.gif

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. 

Screenshot 2026-02-24 104657.png

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. 

Room - Removing Test Rooms.gif

Value

  • Add Session ID
  • Change the agregation to Count All (This counts the total number of sessions using each room).
Room - Adding Session ID.gif

Important to note - Using Count All ensures Analytics counts every session assigned to the room, rather than just a single occurrence.

Room - Showing total values.gif

It is also possible to alter the value text title from '# of Session Id' to something more meaningful.

Room - Altering Values Name.gif

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)

Screenshot 2026-02-24 112728.png

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
Room - Adding Session ID 2.0.gif

Analytics does not automatically display duplicate names. Adding Session ID ensures sessions with the same name appear individually.

Screenshot 2026-02-24 114629.png

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.

Room - Moving Session ID.gif

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.

Room - Sorting.gif

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.