ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
How to use this Template
3
4
1This template works best with Google Chrome and Mozilla Firefox and seems to crash Apple Safari and mobile browsers.
5
2This template requires PagerDuty's Advanced Analytics, whose CSV export contains 22 columns. If your CSV export contains only 6 columns, please contact us to upgrade your PagerDuty plan. More details here: https://support.pagerduty.com/hc/en-us/articles/204467154-How-to-use-the-new-Advanced-Analytics-CSV-Export
6
3Create a copy of this template: "File" --> "Make a copy..."
7
4Download the CSV data from your PagerDuty account in one of these 3 ways:
1) Visit System Report, click any View Incidents link, and click Download CSV.
2) Visit Team Report, click See All Incidents from [dates], and click Download CSV.
3) Visit Incidents Report, and click any Download CSV link.
8
5Replace the entire contents of the Input sheet with your data, including the header row. The easiest way to do this is to select the Input tab, then go to "File -> Import." Upload the CSV data from your computer, then select the "Replace current sheet" option under "Input Actions."
9
6Browse the various available Pivot Tables. Please note that you might need to edit the report filters; Google Spreadsheet struggles sometimes when you replace the source data for Pivot Tables. Excel outright crashes and often corrupts the workbook, so at least this is an improvement...
10
7Look in this document for comments in the Pivot Tables for descriptions and usage suggestions. The comments are not carried over when you make a copy.
11
8Please create your own Pivot Tables and reports and share them with us! Provide feedback here: http://pduty.me/CSVFeedback
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100