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

Administrator Assigned Agent as Docked Filter for existing report: What table and how to?

edited Dec 1, 2022 6:42PM in Reporting & Analytics for B2C Service 2 comments

Summary:I added to a column after I have join the tables in a report and in a type column I added as filter: first(accounts.display_name, transactions.created). I also added docked filter with the following joining the tables with type_4= Assigned or Created = transactions.trans_type , and I'm not getting consistent results. Created provides more consistent results but not perfect. It skips and provides the final assigned when the agents are few reassigned in the audit log. I don't understand why is happening?

What are my options for this? I want the very first agent the incident was assigned by administrator.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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