Can someone help me?

[Vince0511]

I've searched the whole internet for this.
IMO it's very standard what I want to do.

I want an custom report, what will look like this:

Ticket# | QueueName | AgentName | AgentName | Total
=====================================================
T-5425 | RedQueue | 60 minutes | 15 minutes | 75 minutes
T-5276 | BlueQueue | 20 minutes | 60 minutes | 80 minutes
T-5667 | RedQueue | 40 minutes | 30 minutes | 70 minutes
=====================================================
Totals per agent | 120 minutes | 105 minutes |

How do i create an report like this?

Grtz.
Vincent

[crythias]

This also assumes that the queue never has changed or is in the current named queue at time of query?
and what else ... you want self reported time per agent summed?

If the agents are known and static, something like:

Code: Select all

select t.tn 'Ticket#', q.name Queue, SUM(CASE WHEN ta.create_by=2 THEN ta.time_unit ELSE 0 END) Bob, SUM(CASE WHEN ta.create_by=3 THEN ta.time_unit ELSE 0 END) JIM, SUM(ta.time_unit) Total from ticket t left join time_accounting ta on ta.ticket_id=t.id left join queue q on q.id=t.queue_id