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.
Hi :)
If it the first activity of the cycle is always “Change Assignment Group” you could go for a PQL which calcs the time difference between this activity (with remap timesstamps) and the last timestamp of the incident (PU_last),
Let me know if this helps you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.