Run a report on Time worked

simonfurnish
Giga Contributor

Hi,

I would like to run a Weekly report based on the "Time Worked" of each ticket that has been handled by my Group (queue) and if possible each user in that group. Ideally this would have to cover all forms of Tickets (Incidents/Requests/Changes) etc etc.

Can this be done? I'm using the "Time Worked" Table but I don't have enough understanding of what I need to add in the conditions ?

8 REPLIES 8

Michael Fry1
Kilo Patron

I would probably do a Pivot report. Something like this:


aa.jpg


Many Thanks... I will try this method and see if it works


Michael,   I tried running this report based on the criteria you posted but did not get the results.   I'm still playing around with it.   My question is for this to work is there anything on the backend of the system which needs to be enabled in order to get the results from this table?   Thanks Ed


The Time Worked field (timer) needs to be added to the forms (Incident, Problem, Change, RITM, etc) and time recorded for the task.