PagerDuty's Advanced CSV Export Template

	A	B
1
2		How to use this Template
3
4	1	This template works best with Google Chrome and Mozilla Firefox, and seems to crash Apple Safari and mobile browsers.
5	2	This template requires PagerDuty's Advanced Analytics, of which the CSV export contains 22 columns. If your CSV export contains only 6 columns, please contact our Sales team to upgrade your PagerDuty plan. More details are available in our Knowledge Base.
6	3	Create a copy of this template: File > Make a copy...
7	4	Download the CSV data from your PagerDuty account in one of these 3 ways: 1) Visit the System Report, click any View Incidents link, and click Download CSV. 2) Visit the Team Report, click See All Incidents from [dates], and click Download CSV. 3) Visit the Incidents Report, and click any Download CSV link.
8	5	Replace 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	6	Browse the various available Pivot Tables. NOTE: Google Spreadsheet struggles sometimes when you replace the source data for Pivot Tables. If you are not seeing all data in the pivot tables when using this template, check your report editor for applied filters: Select the cell with missing data and the Pivot Table Editor will appear on the right. Under any of the Filter fields, click Show: [x] Items and click either Select All or the fields you would like to see. Excel outright crashes and often corrupts the workbook, so at least this is an improvement.
10	7	Look 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	8	Please create your own Pivot Tables and reports and share them with us! Provide feedback here.
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