Question

How to summarize time spent by each workgroup on re-assignment of an incident?

Hi,

Can you help me with a PQL that can showcase total time spent by each workgroup on an incident?

The incidents can be re-assigned between different workgroups in its life cycle.

output required

Workgroup Avg time spent on incidents Volume of Incidents handled

A XX mins. 10 incidents

B XX mins 20 incidents

Example data below.

C

+7

Hello! Please share the relevant tables, fields, and table relationships if necessary so that I can better assist.

In the meantime, check out some examples here that might be relevant to you.

Sign up