Recent searches


No recent searches

Metrics and attributes for Zendesk Support



image avatar

Rob Stack

Zendesk Documentation Team

Edited Jan 08, 2025


3

136

136 comments

image avatar

Devan La Spisa

Zendesk Community Manager

Hello @...,

I would recommend utilizing the following metric in your report. You can find more info on this and more in our Metrics and Attributes article.

Requester wait time (min) The number of minutes a ticket spends in the New, Open, and On-hold statuses. This number is only measured after a ticket status is changed from New/Open/On-hold/Pending/Solved/Closed.

(Requester wait time (min))

 

Best regards. 

0


I have a question about the metric Field changes Time (min)). Im building a calculated metric using the next code 

IF(
[Changes - Field name]="Motivo Contacto"
and [Changes - Previous value] = NULL
AND [Changes - New value]!= NULL
) THEN VALUE(Field changes time (min))
ENDIF

When I use the calculated metric these returns an emptyvalue. Why could occured that?

0


image avatar

Elissa Tikalsky

Zendesk Digital Resources Team

Hi @...

I checked in with one of our Explore team and they said the metric you made may be returning empty values for a number of reasons: you may have misspelled the field name, you could be using the wrong dataset in the report you're using it in, there may be no tickets that have Motivo Contacto as a value in the subset of ticket's you're looking at.

Another good point is that if at any point in the life of the ticket that field changed to NULL, even if it is not NULL now, the code you have excludes that ticket. So for tickets that change back and forth, those would not show up with this metric.

This recipe may help you get it sorted out a bit: Explore recipe: Reporting on the duration of fields.

If that does't help I'd recommend contacting support so one of our advocates can help you troubleshoot in context and pinpoint what is going wrong!

0


The Update - Timestamp Attribute appears to be missing from the Dataset for Support Updates. I'd love to know how this is calculated, as I'd like to make one that drops off the seconds from this timestamp. 

0


image avatar

Rob Stack

Zendesk Documentation Team

Hi CJ Johnson, thanks for the question. As there are a bunch of different time-based attributes, we don't list them all individually. There are a couple of ways you could tackle this:

1. Create your own attribute with just the elements you need like Year, Hour, etc. There's a great example of this at https://support.zendesk.com/hc/en-us/articles/360022298254
2. I think that the timestamp is always exactly the same length so you should be able to create a standard calculated attribute that returns only the first 16 characters of the Update - Timestamp attribute. The formula would look something like:

LEFTPART([Update - Timestamp],16)

I hope this helps to spark some ideas!

-1


Does an Answer Bot reply count as a agent First Reply? 

0


image avatar

Brett Bowser

Zendesk Community Manager

Hey David,

Excellent question! Answer Bot reply does not count towards the First Reply Time metric. FRT requires a public response from an agent on the account.

Let me know if you have any other questions!

1


Awesome! Thank you.

0


I'm wondering if there is a way to get the (Agent Replies) metric on the Tickets data set to reflect only public comments by agents that do not contain a specific string. I'm noticing that this metric is pulling in values when we've merged a ticket. I wouldn't count this as a "reply" to the requester. Is this possible? So in my use case, I'd want to be able to have a metric called like "Actual Replies" which would be the same as (Agent Replies) minus comments that include the string "was closed and merged into".

1


Is there any plan to include an "end-user replies" in the Support Default dataset? It seems extremely strange that it's not available in this one. 

1


image avatar

Elaine

Zendesk Customer Care

Hi Crawford,

Agent Replies metric always counts all public replies that are sent by your Agents within a ticket.

Agent Replies      The number of public replies added to a ticket by an agent.

If you're referring to the merging process where you're making the merge comments that include the string "was closed and merged into" public, you actually have the option to make this private so that this comment will not be included in the count of Agent Replies moving forward (kindly see Step 5 on To merge one ticket into another ticket in the article I mentioned above).

You can also set the default privacy for all ticket comments which can be done by an Admin to make merge comments deselected, and for them to be posted as a private comment by default.

Hope I was able to clear this out. Cheers! :)

0


image avatar

Elaine

Zendesk Customer Care

Hi CJ,

If you use the Ticket updates Dataset in creating a query, you can actually find the End-user comments as a Metric.

End-user comments The number of end-user comments on tickets. IF ([Comment present] = TRUE AND [Updater role] = "End-user") THEN [Update ID] ENDIF

Hope I pointed you in the right direction. Cheers :)

-1


@... That doesn't help me unfortunately, I mentioned I was asking about the Support Default dataset. You cannot use the End User comments very effectively at all in the Updates dataset, because it gets constrained by the time frame. So if you want to see # of end user replies  on tickets created last week, you can't, because then it will only count end user replies at the time of the ticket creation, which is not helpful. That is why my question called out the default dataset. Additionally, the default set has agent replies, but not end-user, which really feels like an oversight. 

2


image avatar

Elaine

Zendesk Customer Care

Sorry if I wasn't able to answer you in one go. Lemme try again, CJ. :)

You can actually use the End-user comments from the Ticket updates Dataset as how you're expecting it.

You can use the ticket creation date as a filter and then use any ticket update metrics on your query to show the data that you needed just like on the screenshot below:

As you can see, the End-user comments do not show just the number upon creation of a ticket only which should be a value of 1. Instead, it actually shows the total number of End-user comments in a ticket's lifetime.

I hope this time I was able to provide you the expected answer. Cheers! :)

-1


Hi Elaine,
Try it again with "Tickets Created" as the Metric and end user replies as the attributes, and you should get 0s across the board. My request that end user replies be included in the Default dataset still would be helpful, IMO. This was available like this in Insights. 

-1


Is there a way to show/calculate the age of unsolved tickets in business hours/days?

0


image avatar

Marco

Zendesk Customer Care

Hi Allen,

Thanks for reaching out regarding this. You can use the metric "Unsolved tickets age (days)" for this, similar to what is described in this post: https://support.zendesk.com/hc/en-us/community/posts/360029582253-Unsolved-Ticket-Aging-Reporting

This would unfortunately not be able to only show business days, and there is no available metric at the moment that would achieve this. I would suggest posting this as a feedback: https://support.zendesk.com/hc/en-us/community/topics/360001200913--Feedback-on-Explore-

Hope this helps! Cheers!

Marco M. | Zendesk Support

0


How do I create an attribute that shows the date a ticket's status was changed from solved to closed? The new feature of being able to redact on a closed tickets will pose a problem in our current queries. It appears that if you redact on a closed ticket, the 'Ticket updated - date' field is updated to the date the redaction took place. We are displaying 'Ticket updated - date' with the 'Status' of closed on many queries since before this new feature, that date would never change. 

0


It is crazy to me that you have locked down the filtering of this dataset by at the very least Organizations, but ideally anything more than what is allowed right now. By not allowing this, this dataset is completely useless to me.

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi April,

You can create an attribute that could identify the timestamp/date that the status was changed to Closed is through the Ticket updates dataset. Only through the Updates dataset can you create this custom date attribute. Here's how the formula should look like:

IF ([Changes - Field name]="status" AND [Changes - New value]="closed")
THEN [Update - Date]
ENDIF

With this, you can create a report based on or filtered by the date the tickets were set to closed. If your reports are under the Tickets dataset, then I'm afraid there is no workaround for this.

1


Hi team @...

So our team wants to do quality assurance for our agent by selecting tickets only works by one agent to measure their issue handling for customer inquiry. Is there any metrics that I can use to do that?

Context:
- when we tried to do sampling, one ticket can contain more than 1 agent to solved/closed the ticket

- we just want to select tickets who works by 1 agent only

 

could you help with that? Thank you

1


image avatar

Rosie

Zendesk Customer Care

Hi Kautsar, 

To specifically report one agent to measure his ticket handling, you can add the attributes "Assignee name" then select the agent name and apply. 
 
Please make sure that you select the Tickets dataset

A simple query may look like this for your reference: 

 

 

-1


Could you please update this article with the following metrics:


Number of New Tickets

  1. This month vs. last month (MTD vs. LMTD)
  2. This month vs. same month last year (MTD vs. LYMTD)

Number of Solved Tickets

  1. This month vs. last month (MTD vs. LMTD)
  2. This month vs. same month last year (MTD vs. LYMTD)

Created Tickets vs. Solved Tickets variance on:

  • all the normal date ranges: a single date, last week, last month, etc.

1


The Metric "Agents" calculation is non-functional and does not return what is listed as what it is supposed to: 

Agents The number of active agents and administrators in your Zendesk account. IF ([Requester status] = "Active" AND [Requester role] != "End-user") THEN [Requester ID] ENDIF

This formula does not return "the number of active agents and administrators on your account". It returns stuff like a 5 agent count for a single Assignee name, and simply does not do what it says it does. 

1


CJ,

What may work for you is a D_COUNT of Assignee as a metric with Assignee Name or Assignee Email in the rows section.  And then filter that on Assignee Role = Agent.

0


Hi Taylor, 
Unfortunately, it does not, I opened a ticket with Support and they agreed the issue is how this metric is written, and that it cannot return "all active agents and admins". 

Edit: Part of why I'm posting because that support conversation was like, a month ago and this article is still wrong, the formula hasn't changed, so I figured I'd warn others that yeah, this metric just doesn't work. 

0


Gotcha. 

The D_Count(Assignees) seems to work for me with Assignee Email on rows, filtering to Assignee Role = Agent.  It lists a 1 for those still active, and a 0 for those who are no longer with the company.  Of course that doesn't get me all the way to where I want to go, so I've got to filter out agents that have a license in our instance that are in a different section of the company.


Hopefully they fix the Agent formula soon.

0


Hi guys, 

Currently, I'm using a calculated attribute based on the ticket subject, however, instead of using the ticket subject I want to use the ticket note internal/public to have an in depth analytics. Do you this this can be done? Is yes, what variable I should use in the attribute syntax? 

If not possible, is there an ETA when this will be possible? 

0


Hi everyone,

Is there a way to set up a metric that can calculate the "Avg Number of Solved Tickets" and "Avg. Number of Updated Tickets" per "Hour"? I'm trying to use these metrics to determine how many tickets each agent is solved or updated (tracking these two separately) each hour to figure out daily ticket goals per person. Thanks1

0


image avatar

Erin O'Callaghan

Zendesk Documentation Team

Hi Raúl, you should be able to create standard calculated metrics with the following formulas to get these numbers:

  • Average tickets solved per hour: COUNT(Tickets) / DCOUNT_VALUES([Ticket solved - Hour])
  • Average tickets updated per hour: COUNT(Tickets) / DCOUNT_VALUES([Ticket updated - Hour])

1


Please sign in to leave a comment.