I've got a dataset that lists records of resolved tickets by date and agent name (as well as a few other criteria).
I created a pivot table that has the agent names in the row field and the resolution dates in the column field so I have a daily count of number of resolved calls by agent as well as a month total per agent at the end of each row.
The resultant table is shows a blank cell on the days that the agent didn't work so I had hoped to figure out a way to get the pivot table to tell me how many days the agent worked that month as well. However even using calculated fields I cannot figure it out. Any help would be gratefully received.
<tbody>
</tbody>
I created a pivot table that has the agent names in the row field and the resolution dates in the column field so I have a daily count of number of resolved calls by agent as well as a month total per agent at the end of each row.
The resultant table is shows a blank cell on the days that the agent didn't work so I had hoped to figure out a way to get the pivot table to tell me how many days the agent worked that month as well. However even using calculated fields I cannot figure it out. Any help would be gratefully received.
A | B | C | D | E | F | G | H |
3-Jul | 4-Jul | 5-Jul | 6-Jul | 7-Jul | 8-Jul | Grand Totals | |
aaron | 4 | 6 | 6 | 3 | 5 | 24 | |
mark | 5 | 4 | 5 | 6 | 6 | 26 | |
pablo | 8 | 7 | 4 | 5 | 24 | ||
Grand Totals | 17 | 10 | 13 | 8 | 10 | 16 | 74 |
<tbody>
</tbody>