Run a report on Time worked

simonfurnish
Giga Contributor

‎01-06-2016 08:48 AM

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 ?

0 Helpfuls
  • 6,883 Views
8 REPLIES 8

Michael Fry1
Kilo Patron

‎01-06-2016 10:24 AM

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


aa.jpg


Preview file
74 KB

simonfurnish
Giga Contributor
In response to Michael Fry1

‎01-07-2016 04:29 AM

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


0 Helpfuls

edmicciulli
Kilo Explorer
In response to Michael Fry1

‎01-27-2017 07:45 PM

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


0 Helpfuls

Michael Fry1
Kilo Patron
In response to edmicciulli

‎01-28-2017 09:34 AM

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


0 Helpfuls