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 for when another agent enters a note

Received Response
17
Views
5
Comments
edited Jun 25, 2019 2:06PM in Reporting & Analytics for B2C Service 5 comments

Summary

We are trying to flag/highlight a row on a report that indicates when another agent has logged a note

Content

We are trying add an exception to a report that indicates when the last agent who logged a note is not the agent that is assigned to the incident.  I have tried this formula but it gives me an error:

if(last(threads.acct_id,threads.entered)<>incidents.assgn_acct_id,1,0)

 

The error I received is:

"The report contains the following errors:

Executing view query failed.

You will need to edit the report to resolve these errors."

The background on this request:  When an agent comes into work in the morning (or at anytime), they want to see if any other agent has put any notes on their tickets.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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