You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report on incidents solved by the original assigned agent

Accepted answer
34
Views
11
Comments
edited Nov 21, 2018 4:41PM in Reporting & Analytics for B2C Service 11 comments

Summary

We require a report that provides a count of incidents solved by an agent that were not reassigned before being marked as solved

Content

We are able to report on the count of incidents solved by an agent but are having a hard time determining a count of incidents that were solved but have not been reassigned.

Column 1 accounts.full_name

Column 2 count(distinct if(transactions.trans_type= 6 & transactions.id1 = 2, 1))

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!