Viewing Snapshot Data as a Table

The Tables page in X25 Analytics lets you browse all event and location data within a single snapshot. You can filter the data according to predefined data filters and zoom in on specific groupings such as organizations, buildings, and breakpoints.

The snapshot breadcrumbs at the top of the page have two drop-down menus which allow you to refine the content displayed on the page.

  • Filter options, which hide events or locations that don't belong in a selected filter.
  • Group options, which divide the events or locations into sub-groups. Click a group's name to see detailed information about its contents.

At the bottom of each table is the option to Export data. Clicking this button downloads the filtered table results as a CSV file.

A table of data showing all events in a snapshot. There are drop-down menus with filtering and grouping options.Image: Tables page in X25 Analytics.

Event Details

The columns available when viewing event data change based on the selected grouping option. When viewing the "All Events" list, you can choose which columns are visible via the checkboxes below the table.

You can select a Standard Schedule from the drop-down on the right. This will show whether each event's meeting patterns are compliant with that schedule.

All Events

When "All Events" is selected, these columns are shown:

  • Event Name - The name of the event. If a class has multiple meeting patterns, each appears separately with the same name.
  • Headcount - Either the registered or expected headcount of the event, depending on filter options.
  • Org - The primary organization for the event.
  • First/Last - The first and last dates of the event, in YY/MM/DD format.
  • Start/End - The start and end time of the event, in 24-hour format.
  • Days - The days of the week when the event meets. (M=Monday, T=Tuesday, W=Wednesday, R=Thursday, F=Friday, S=Saturday, U=Sunday)
  • Mins - The duration (in minutes) of the event.
  • Compliant - Whether or not the event's meeting pattern matches the selected Standard Schedule
  • Util - The event's seat utilization (its enrollment divided by the capacity of the assigned location).
  • Location - The name of the assigned location, if any.
  • Cap - The assigned location's maximum capacity.
  • Building - The assigned location's building.

Events Grouped By...

When events are grouped by some option, such as enrollment, organization, or breakpoint, these columns are shown:

  • Group Name - Indicates the selected grouping. Click the name of a group to see more details about its contents.
  • # of Events - The count of events within the group.
  • Headcount - The total registered or expected headcount of all events in the group, depending on filter options.
  • Avg. Duration - The average duration (in minutes) of events in the group.
  • Occurrences - The total number of occurrences among all events in the group (within the date range of the selected filter).
  • Meeting Hours - The total duration (in hours) of all occurrences among all events.
  • Contact Hours - For each event, its meeting hours are multiplied by its enrollment and added together to reach this value.
  • Seat Utilization - The average utilization (enrollment divided by capacity) of all events in the group.
  • Average Compliance - The percentage of events whose meeting patterns match the selected Standard Schedule

Group Details

When you click on a group's name you can see a list of all events in the group. These columns are shown for each event:

  • Name - The name of the event. If a class has multiple meeting patterns, each appears separately with the same name.
  • Sponsor - The primary organization for the event.
  • Headcount - Either the registered or expected headcount of the event, depending on filter options.
  • Days - The days of the week when the event meets. (M=Monday, T=Tuesday, W=Wednesday, R=Thursday, F=Friday, S=Saturday, U=Sunday)
  • Start/End - The start and end time of the event, in 12-hour format.
  • Duration - The duration of the event, in minutes.
  • Occurrences - The number of occurrences (within the date range of the selected filter).
  • Meeting Hours - The total duration (in hours) of all occurrences.
  • Contact Hours - Meeting hours multiplied by enrollment.
  • Location - The name of the assigned location, if any.
  • Preference/Feature Match - How well the event's location matches the sponsor organization's partition preferences as well as the event's location feature preferences. Learn more about these columns on our page for partition and feature matching.
  • Average Seat Utilization - The event's enrollment divided by the capacity of the assigned location.
  • Compliant - Whether or not the event's meeting pattern matches the selected Standard Schedule

Location Details

The columns available when viewing location data change based on the selected grouping option.

All Locations

When you choose an option to group locations (such as enrollment, organization, breakpoint, or "all rooms") these columns are shown:

  • Group Name  - Indicates the selected grouping. Click the name of a group to see more details about its contents.
  • Count - The count of locations in the group.
  • Capacity - The total capacity of each location in the group.
  • Events - The total number of events assigned to locations in this group.
  • Occurrences - The total number of occurrences among all those events.
  • Meeting Hours - The total duration (in hours) of all occurrences among all events.
  • Contact Hours - For each event, its meeting hours are multiplied by its enrollment and added together to reach this value.
  • Room Utilization - The average amount each location is "in use". Calculated as the number of hours when an event is assigned to a location divided by the total hours in a day (within the start and end times defined by the current filter set options).
  • Seat Utilization - The average amount each location is "full". Calculated as each event's enrollment divided by the location capacity.
  • Controlled By - The owner of the location.
  • Room Use Code - Your institution's code for the location's "room type" (often matching FICM [Postsecondary Education Facilities Inventory and Classification Manual] standards)

Group Details

When you click on a group's name you can see a list of all locations in the group. These columns are shown for each location:

  • Name - The name of the location.
  • Building - The location's building. This is used in some reports.
  • Controlled By - The "owner" of the location (determined by the custom location attribute "X25 Owner Organization" in 25Live).
  • Partition - The name of the location's partition. This is used for Optimizer placement.
  • Capacity - The location's maximum capacity. Any alternate layouts on the location are not included.
  • Room Use Code - The code for the location's "room type", typically matches FICM (Postsecondary Education Facilities Inventory and Classification Manual) standards.
  • Events - The total number of events assigned to this location.
  • Occurrences - The total number of occurrences among all those events.
  • Meeting Hours - The total duration (in hours) of all occurrences among all events.
  • Contact Hours - For each event, its meeting hours are multiplied by its enrollment and added together to reach this value.
  • Room Utilization - The average amount each location is "in use". Calculated as the number of hours when an event is assigned to a location divided by the total hours in a day (within the start and end times defined by the current filter set options).
  • Seat Utilization - The average amount each location is "full". Calculated as each event's enrollment divided by the location capacity.

Video Demo