Users with Advanced Analytics available to their account can download a CSV file with more information to open up a number of powerful reporting options for your PagerDuty account. You can utilize the raw data as is, or use the generated CSV as a starting point to build your own custom reports.
With basic analytics, the exported CSV will include the following columns of information:
- Opened On
- Resolved On
- Resolve By
- # Escalations
With advanced analytics, the exported CSV will include additional columns of information:
- incident_number (# column in basic report)
- service_name (Service column in basic report)
- seconds_to_resolve (Duration column in basic report)
Note: The escalation_count is the number of people the incident was escalated to.
Options to download the CSV
On the Analtyics page:
- Go to System report, click any View Incidents link, and click Download CSV.
- Go to Team report, click See All Incidents from [dates], and click Download CSV.
- Go to Incidents report, and click any Download CSV link.
The CSV you download will be filtered based on the report selected before hitting the download link: Service or Escalation Policy for the System report, Escalation Policy for the Team Report, and Date Range for any report.
The CSV is currently limited to a maximum of 10,000 records. After 10,000 rows, the export will be truncated, so if your CSV contains exactly 10,000 rows, you may have partial data.
Template for pivot table creation
You can access a template that will provide different ways to use the Advanced Analytics CSV at the link below. The template is view only, but contains instructions to make a copy of the file, fill in data from your CSV, and use the pivot tables to see a full spectrum of what’s happening with your PagerDuty incidents.
If you are not seeing all data in the pivot tables when using this template, check your report editor for applied filters. Under any of the Filter fields, click Show: _ Items and click either Select All or the fields you would like to see.