• Pedro Rodrigues

  • March 29, 2022 11:09

  Community Moderator

  Hi Bharath Bhushan, I'd suggest replacing 'Updater name' with 'Updater role', for example:

  IF ([Comment present] = TRUE 
  AND [Updater role] != "End-user" AND [Updater role] != NULL
  AND [Comment public] = TRUE) 
  THEN [Update ticket ID]
  ENDIF

  Note: we're also including Admins as valid updaters in the query above. If you only want to look at agents, [Updater role] = "Agent" will suffice.

• Bharath Bhushan

  • March 30, 2022 01:58
  • Edited

  Hello Team,
  
  Tried the above-mentioned query and still doesn't work. 
  It doesn't show counts if the ticket is currently not under the agent names even though there was a public response made on the ticket yesterday before escalating it to another queue.

   

  The query only shows a count of tickets if it's under the agent's name currently. 
  
  I am looking for a query that shows a count of tickets even if the ticket is not under the agent's name currently. 
  The query should add a count of the ticket if the agent has made a public response/comment to it. 
  The count should show up irrespective he/she is the current owner of the ticket. 
• Pedro Rodrigues

  • March 30, 2022 10:15

  Community Moderator

  Hi Bharath Bhushan, that's odd, it should work. If you can please confirm the following:

  • Are you creating this standard calculated metric in the Tickets or in the Updates history dataset? (My previous comment assumed we're working under the latter)
  • When you say "under the agent", you're referring to the Assignee value, is that correct?

  Also, is it possible for you to share a screenshot of the query (omitting any private data), please?

  I just reviewed this in my account and it works fine.

  

  If we take a look at the second agent, for example, the query shows a total of 15 tickets updated, but only 7 updated with at least one public comment (i.e. the standard calculated metric above).

• Bharath Bhushan

  • March 31, 2022 03:10

  Hello Team,
  
  I have tried using the query above and it doesn't fetch the data I need. 
  Please watch the video https://vimeo.com/694250919 completely and assist further.
  
  I have recorded the issue so that it can be easily conveyed. 

• Pedro Rodrigues

  • March 31, 2022 11:34

  Community Moderator

  Hi Bharath, unfortunately I can't access the video (even after logging in to the platform), is there a way to share a public link, please?

• Bharath Bhushan

  • April 03, 2022 05:16

  Hello Pedro, please try accessing https://vimeo.com/user105616991/download/694250919/c36c1af89f link. This should let you download the video. 

• Pedro Rodrigues

  • April 05, 2022 14:18

  Community Moderator

  Hi Bharath Bhushan, sorry for the late reply, and thank you so much for the video evidence!

  It is possible that your custom attribute "Tier Group" is affecting the query. Does this formula use [Ticket group] or [Update ticket group] (it should use the second).

  Can I ask you to please try the following in a brand new query?

  • Use the formula I shared (with the [Updater role] condition) to calculate (remove [Updater name]
  • Columns: Updater - Hour
  • Rows: Updater name
  • Explosions: Update ticket group
  • Filters: Updater role ("Agent" or exclude "End user"), Update - Date

  Does this produce the expected results? And can you filter for ticket 8378328 and obtain results? (make sure to filter for an Update - Date that considers this ticket's creation)

  Thanks in advance!

• Bharath Bhushan

  • April 06, 2022 02:21

  Hello Pedro,

  Thank you for getting back to me. We are testing this now and will get back to you ASAP.

Please sign in to leave a comment.