I have a report which shows number of calls per agent by request mode.
However if for a reporting period there were no calls logged by a particular request mode or by an agent the column or row does not appear on the report.
Because I export this report and it is combined with data from other sources I need the data to be consistent. Is there a way to achieve this?
Hopefully the two data sets below show what I mean:
This one has data for all techs (nobody was on holiday! and those are not their real names
), but no calls were raised by people walking into IT that week
|
E-Mail |
Phone Call |
Count |
Tech1 |
0 |
1 |
1 |
Tech2 |
0 |
5 |
5 |
Tech3 |
0 |
46 |
46 |
Tech4 |
0 |
7 |
7 |
Tech5 |
0 |
16 |
16 |
Tech6 |
0 |
6 |
6 |
Tech7 |
0 |
3 |
3 |
Tech8 |
0 |
40 |
40 |
Tech9 |
0 |
1 |
1 |
Tech10 |
0 |
19 |
19 |
System |
178 |
0 |
178 |
Count |
178 |
144 |
322 |
Where as this week Tech4 and 7 were on leave but we had some walk ins
|
E-Mail |
InPerson |
Phone Call |
Count |
tech1 |
0 |
0 |
6 |
6 |
tech2 |
0 |
0 |
10 |
10 |
tech3 |
0 |
0 |
2 |
2 |
tech5 |
0 |
0 |
2 |
2 |
tech6 |
0 |
0 |
1 |
1 |
tech8 |
0 |
1 |
46 |
47 |
tech9 |
1 |
0 |
21 |
22 |
tech10 |
1 |
4 |
3 |
8 |
System |
116 |
0 |
3 |
119 |
Count |
118 |
5 |
94 |
217 |