Skip to main content

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.

image

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.


Reply