Pesquisas recentes


Sem pesquisas recentes

Number of tickets without a Public Reply from the Requester



Publicado 13 de ago. de 2024

Hello everyone, 

 

We're trying to create a report in ZD Explore that lists the number of tickets without a Public Reply from the Requester.

 

We already know how to create a report for Public Replies made by agents (Agent Replies Brackets attribute). 

 

Any ideas how we can get the same report, but for Requesters (users) rather than Agents? 

 

Help is greatly apprectiated. 

 


0

2

2 comentários

image avatar

Pedro Rodrigues

Community Moderator

Hello Abdulqader Haddad, when we want to obtain “without a public reply from the Requester" we can assume two scenarios:

  • Inbound tickets: there is always one requester comment at least, so I assume you need the number of tickets without any subsequent requester replies, which means we need to identify tickets submitted by end-users with a single requester comment
  • Outbound tickets: in this case, we need to identify tickets submitted by agents where the number of end-user comments is zero

We can achieve this by creating your report and standard calculated metric under the “Updates history” dataset.

Your metric will look like this:

IF (ATTRIBUTE_FIX(D_COUNT(End-user comments), [Ticket ID]) = 1 
AND [Submitter role] = "End-user") 
OR (ATTRIBUTE_FIX(D_COUNT(End-user comments), [Ticket ID]) = 0 
AND [Submitter role] != "End-user") 
THEN [Update ticket ID]
ELSE NULL
ENDIF

This metric should be used with the COUNT or D_COUNT aggregators. 

Example:

Our metric is validating 1.884 tickets in the table above, and we can see that two tickets were outbound (i.e. created by agents). After checking, these two outbound tickets don't have any end-user replies.

Hope this helps, happy Exploring!

0


Amazing! 
Thanks Pedro, this was extremely helpful. 

 

Have a great one! 

0


Por favor, entrar para comentar.

Não encontrou o que estava procurando?

Nova publicação