Reporting on Time Units

[AndyR]

Hi, we've recently started using time units and made the field mandatory. However it seems there are no reports available for this field?

How do you report on things such as :

1. time units per agent
2. time units per ticket type by agent
3. time units by type by agent

etc?

[crythias]

Check this post: viewtopic.php?f=60&t=12546

[AndyR]

thanks that's a good starting point - trouble is I don't have any concept of SQL!

The first one runs well, but i'd like to be able to break it down further i.e. not only which agent spent the time but also who for (using one of our other fields).

I imagine this is easy for a SQL guru. Thanks for the advice though

[crythias]

I use customer_id to do the "who for" part. It works quite well for billing purposes.

[AndyR]

i'd like to include the field TicketFreeText1

is there any easy way to do that? it contains a list of our Sites, so I could see time spent by person by site?

[crythias]

Please kindly edit your signature (see mine) I can't necessarily guess your needs or capabilities of your OTRS implementation without version.