Goal

Identify all resolved tickets in time-period.

Notes

MAJOR

MINOR

"Assigned Group" is what we see as the assigned group when we open a Remedy ticket. Confirm if this is the field Remedy reports in their "Assigned Group" header, as is likely the case.

Reason for question: CIT's HelpDesk practice is to "take" tickets from us, changing the "Assigned Group". There is apparently another (hidden?) field that is the group which created the ticket, regardless of how "Assigned Group" subsequently gets changed.
- For tickets "born" in Chemistry/ Physics, that other field is the one to use, regardless of which group/ person closes it. In our report, would show as closed, but not by one of us (one more line).
- For tickets "born" elsewhere but ended up in Chemistry/ Physics, the normal "Assigned Group" field is the one to use, along with our staff member who closed the ticket. That's happening now.

Process

I wrote to Frank 1/14/16 to request report from Greg Christofferson. Excerpt:

Thanks for discussing Remedy reports with me this morning, inspired by Greg Christofferson’s <gc88> recent referral to me. Greg thought he was already sending you the report data that I had discussed with him I wanted for our group.

What you and I discussed is if we could start with getting data for one month, to start. Get data for each of the 4 full-time staff members in Chemistry IT/ Physics IT with how many tickets we resolved in the Chemistry queue. Once we nail down a report with the right info we can broaden the time, include student staff, and pull in data from our other 2 queues (Chemistry 2 and Physics).

Details

This provides us with a measure of volume, to compare with our monthly snap-shots of outstanding tickets.

Process idea: Do for each month (or quarter), starting with the past 6 months (or 2 years).

Implementation ideas

Example 1: Spreadsheet

In the Month of Sept 2015, ChemIT (Assigned groups: Chemistry and Chemistry (L2)) and PhysIT (Assigned group: Physics) resolved x number of tickets. The are as follows (in a spreadsheet):

Assigned Group, Summary, First Name, Last Name, Contact Type, Reported Date (Why are there two? Do they differ?), Responded Date, Last Resolved Date, Closed Date, Last Acknowledged Date, Last Modified, Re-Opened Date, Service, Status (is either resolved or (auto-)closed, depending on query date), Assignee, Resolution, Customer Building Name, ID.

From Frank, 4/25/16, "Resolved tickets for 3-1 thru 4-12-16":

		Resolved within 1 day	Resolved in more than 1 day	Total
Chemistry	Lulu Zhu	2	8	10
	Michael E Hint	41	32	73
	Oliver B Habicht	9	8	17
	Roger W Garnett	16	8	24
	Total	68	56	124

From Frank, 3/16/16: For January 2016:

Assigned Group	Hours Captured	Assignee	Incident Closed/Resolved
Chemistry	No Effort	Lulu Zhu	14
		Michael E Hint	55
		Oliver B Habicht	14
		Roger W Garnett	18
	No Effort	Sub-Total	101
Chemistry		Total	101

Example 2: Pie charts

Pie chart for ChemIT and separate pie chart for PhysIT showing tickets completed by staff member. Annual snapshot?

Similar to the Library's Desktop Services "DS Resolved Incidents 2014" and "DS Resolved Incidents 2015" web reports.

See also