Recent searches


No recent searches

Creating a query with totals of an attribute

Answered


Posted Feb 01, 2021

Hello

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


0

1

1 comment

Hi Sidd, My name is Tod, and I am with the Zendesk Customer Advocacy Team. First, I'm sorry about the length of time this has taken to get back to you. Regarding the inquiry about the hash value,, we do not measure hash values in Explore. We do, however, have the ability to report on tags, and you could add tags to tickets created in the process you've described if you are using triggers to create these new tickets. By doing that, as per the article Reporting with tags, you could report on the number of tags added to a ticket.

Let me know if you have any questions.

 

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post