Jeri

I'm trying to pull a report on how many times in a given period each agent has updated a custom field. When I build the report in Support:Updates (and use a custom attribute to tell it that I only want it to count updates for when a custom checkbox went from "0" to "1"), it gives me some of the correct tickets for each agent, but not all of them. The vast majority end up in "null" without an updater name attached. How is that possible? How can I get accurate information about who clicked the checkbox? Or at least about who was assigned to the ticket when the checkbox got clicked?

Hi folks! Really hoping you can help me out with this, it's been a perpetual headache. Here's the situation: my org uses three different macros (associated with tags, let's call them 'tag1', 'tag2', 'tag3') that individual agents apply to a ticket when they want to reassign it to a different group (managers and leads). The macro automatically reassigns the ticket when applied.

I want to be able to count how many times per month each agent is triggering each reassignment type. 

For context, this is to quantify agent work on tickets that aren't solved in their name. For instance, if John Doe works hard on a ticket and ends up reassigning it to a manager using one of the reassignment macros, he won't get the solve credit, but we still want to quantify his labor.

My current attempt is using the Support: Updates History dataset to try to find this information. Since I believe Zendesk does not at this moment have a way to track tag use, we have set up an automatic checkbox ("Reassigned") that's triggered when one of the three macros is used.

I have tried to count these occurrences using the following calculated metric:

IF ([Changes - Field name]="Reassigned")
AND
(([Changes - Previous value]="0") OR
([Changes - Previous value]=NULL))
AND
([Changes - New value]="1")
THEN
1
ENDIF

To my way of thinking, this should count each ticket for which the "Reassigned" box gets triggered as 1, and then give me a total of how many reassigned tickets there have been in a given time frame. But the numbers it is yielding are incorrect. Any ideas on how to adjust this calculated metric, or just invent a new one, to get the info I need?