Historical On Call report
As a supervisor, you might want to see details of your team members' on-call times so you can identify trends or coverage gaps, or so you can see how often a specific person has been on-call during a certain period. The Historical On Call report lets you export a spreadsheet (.xlsx file) containing up to 100 days' worth of historical data.
The date when the report began collecting data depends on your region: for instances based in North America, there is no data available prior to February 1, 2020. For instances in the European and Asia-Pacific regions, there is no data available prior to January 1, 2020.
To export the Historical On Call report:
- Navigate to the Groups tab, and then click Historical On Call.
- Use the date pickers to set From and To dates, ensuring that the dates are no more than 100 days apart.
- If you select dates that are more than 100 days apart, the From and To dates adjust automatically to stay within 100 days of each other.
- Set the time zone you want to use to calculate the report.
- Click Export.
- xMatters generates the report and downloads it to your system as an .xlsx file.
There are a few things you might notice when you open and view the downloaded file:
- Each row of the report represents a block of uninterrupted on-call time for a single user at the same escalation level, referred to as a segment. As shifts can span days, weeks, or even longer, splitting shifts into segments allows supervisors to calculate on-call pay without waiting for the entire shift to end. Even a shift that only lasts a few hours can have multiple segments because of shift rotation or temporary absences.
- The report automatically excludes 24x7 shifts with no escalations. These shifts are considered broadcast groups and do not contain shift segments.
- If someone modified an escalation delay during the time period the report covers, it affects shift segments for the current and following shift members.
- The information in the report is based on your permission level, and is restricted to only those users you have permission to access (such as the users you supervise).
- Depending on when they were removed, deleted shifts may still appear in the Historical On Call report.
Each row of the Historical On Call report includes the following information:
|The type of shift; available options include: ON_CALL, ABSENCE, and REPLACEMENTS.|
|A unique identifier that the user will use when logging into xMatters. For example, Mary McBride's user ID is mmcbride. If there are two users named Mary McBride, their user IDs could be mmcbride1 and mmcbride2.|
|The first name of the user.|
|The last name of the user.|
|User UUID||The unique alphanumeric identifier of the user in xMatters.|
|User's Site Name||The name of the user's assigned site.|
|Group Name||The name of the group the user belongs to.|
|Group UUID||The unique alpha-numeric identifier of the group.|
|On-Call Shift Name||The name of the shift within the group for which the user was on call.|
|Holiday Shift||A Boolean value of either TRUE or FALSE that indicates whether the on-call shift was covering a holiday.|
|Shift Occurrence Start||The timestamp of the start of the shift in UTC format (YYYY-MM-DDT00:00:00:000Z).|
|Shift Occurrence End||The timestamp of the end of the shift in UTC format (YYYY-MM-DDT00:00:00:000Z).|
|Segment Time Start||The start time of a portion of a shift.|
|Segment Time End||The end time of a shift segment.|
|Escalation Level||The escalation level of the user. For example, a user could be the primary escalation for one group and the secondary escalation for another.|
|Escalation Time||The elapsed time (in minutes) before an event is escalated.|
|On-Call Time (mins)||The total amount of time, in minutes, that the user was on call.|
|Absence Time (mins)||The total amount of time, in minutes, the user was absent from being on call.|
|Replacement Time (mins)||The amount of time, in minutes, the user replaced another user during their on-call shift. For example, if Mary McBride replaced Steve Smith for an hour during his on call shift, the Replacement Time is listed as 60.|
|Replacement User Name||Displayed only if a Replacement Time was logged. The name of the person who was replaced by the user during the on-call shift. Using the example above, Steve Smith is listed as the Replacement User Name column.|
|Replacement User UUID||Displayed only if a Replacement Time was logged. The unique alphanumeric identifier of the user who was replaced. Using the example above, Steve Smith's UUID is listed in this column.|
|Custom Fields||A comma-separated list of custom fields.|
Interpreting report data
The wealth of data included in an exported Historical On Call report can seem somewhat daunting. For tips on using pivot tables to correlate and parse the data in the report, see this helpful article on the xMatters Support site: Making the most of your Historical On Call report data