I am trying to create a query in Explore wherein I want to capture how many times a value of an attribute is repeated in last 30 days. We have a field in zendesk called "hash value" and when certain conditions are met, multiple tickets may get generated with same hash value. I would like to capture the hash value that is repeated more than 4 times within last 30 days and would like to know the ticket numbers associated with the same hash value.
Unable to figure this one out. Any help would be greatly appreciated. thanks
Iniciar sesión para dejar un comentario.