I have a pivot table that shows service desk metrics (help desk). I can see average time to resolution per incident. Each incident has who was assigned to it. I can build out a pretty graph that shows me average time to resolution for all incidents in a time period. However, I want to create a different series (line graphs) for each manual grouping of person that was assigned the ticket by which level they are (level1, 2 or 3)
For example:
Level 1 = John, Mike, Sarah,
Level 2 = Joe, Shawn, Alice
Level 3 = Mark, Jim, Greg
I want a series (different line on the line graph) for level 1, level 2, and level 3. The data does not have any way for me to tell which level a person is, which is why I'm thinking some sort of filter.
Thoughts?
Bookmarks