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.