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

Need help filtering a column to see only "duplicate" entries

edited May 9, 2018 8:04AM in Reporting & Analytics for B2C Service 3 comments

Content

Hello everyone,

This is my first topic here, if anyone has a solution to my problem I'd be forever grateful. 

I would like to create a report to see "duplicate tickets", meaning tickets that have been created several times instead of just once, by one person. So how could I filter out just the tickets that are created by one person in like let's say a less by 5 minute interval, if that makes sense?

I have the following data available:
incidents.ref_no - the unique identifier of the ticket

contacts.email - the e-mail address of the person that created the ticket

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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