Explore recipe: Agent interactions on tickets

Have more questions? Submit a request

18 Comments

  • Thomas D'Hoe
    Comment actions Permalink

    Hi, 

    Thanks for this one.

    How can I filter this report so that I only see the updates from a specific agent group?

    When I filter on Agent Group I still see agent names that not belong to that specific agent group.

     

    Thanks for the help.

     

    Thomas

    0
  • Andy Killingsworth
    Comment actions Permalink

    Hey, Thomas. 

    Thanks for posting this issue, I'd like to help! To start, I'm not seeing your Ticket Group filter in that screenshot. If that filter was active, I'd expect to see it next to the Updater role filter, above the query display. 

    I tested this kind of filter and was able to make it work within my test account. 

    Here's my copy of this query pre-filter:

    And here it is with the filter applied:

    This filtering also works with the Update ticket group, if you want to filter by the group to which the ticket was assigned at the time of an update.

    Please make sure your filter is appropriately added and let us know if the issue persists!

    0
  • Mistyamber Reynolds
    Comment actions Permalink

    I only want to see ONE agent's comments on tickets by ticket ID.  Whenever I attempt to get this granular, it gives me the TOTAL comments (including the comments by other agents on the same ticket).  I really need to see the single agent's comments.  Is this possible?   Filtering by Updater name and Ticket ID does not help.

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Mistyamber,

    I'm going to bring this into a ticket so our Customer Advocacy team can take a look at this report you've set up.

    If you're filtering by updater and ticket ID I would expect only comments by that particular updater to show up.

    You'll receive an email shortly stating your ticket has been created.

    Cheers!

    0
  • Danny Koss
    Comment actions Permalink

    I'm looking for a way to track which agents change the group assignment of a ticket. 

    In some cases, an agent in group A may assign an unassigned ticket to group B. In others, an agent in group A assigned to a ticket may assign that ticket to group B.

    Is there a way to track ticket group reassignment by agents?

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Danny,

    There are a couple of Explore assignment recipes that may help point you in the right direction:

    I hope this helps!

    0
  • Karolina
    Comment actions Permalink

    Hey 

    How can I modify this so it gives me the number of comments from a specific time frame e.g. last 24 hours or last 7 days? 

    Thanks 

     

     

     

    0
  • Karolina
    Comment actions Permalink

    Referring to the above question - I have now amended the data range. 

     

    If I set this as yesterday, and save it, will the dashboard visual always show me the day before? 

     

    Sorry if it seems obvious. Very new to Zendesk

    0
  • Devan
    Comment actions Permalink

    Hello Karolina,

    Welcome to the Zendesk Community forum! No apologies needed because we are glad you are here and love questions from the Community! To answer your question, 100% yes, if you set this range to yesterday, the dashboard visual will always show you the day before. Let us know if there is anything else we can help with and have a wonderful day!

    Best regards. 


    0
  • Joachim Jonkers
    Comment actions Permalink

    Hi,

    Is there a way to have an overview of the amount of ticket updates per agent (in a stacked column) per month (over the last year for example)? I do not seem to succeed in adding a time range on the x-axis.

    Best,

    JJ

    0
  • Devan
    Comment actions Permalink

    Hello Joachim Jonkers,

    We have you covered! Below are the following steps for creating an overview report on ticket updates per agent. 

    1. The metric you want to use is Agent Updates

    2. Under Columns apply Update - Year, Update - Month and Filter on the appropriate time range

    3. For Rows use Updater name

    4. For Filter use Updater role -> Filter on Agent and Admin

    5. For Formatting: Chart configuration menu -> Row selector, hit hide row selector, and under Selected position choose Select all

    Best regards. 

    1
  • Joachim Jonkers
    Comment actions Permalink

    Thanks a lot for the help Devan, this has been a lifesaver. I can make future reports myself based on your help!

    0
  • Sharin Kaur
    Comment actions Permalink

    Hi there,

    My issue starts right from the beginning unfortunately.

    1. In the Metrics panel, click Add.
    2. From the list of metrics, choose Comments Public comments and Comments Internal comments, then click Apply.

    I don't have "Comments" in the list of Metrics (screenshot below) and of course I'm trying desperately to get an understanding of how many public and internal comments are happening per agent within a timebox. Thank you so much for your help! 

    0
  • Melissa Norton
    Comment actions Permalink

    Hi Sharin Kaur,

    It looks like you are using the incorrect dataset. Instead of "Support: Tickets," you will want to use "Support: Ticket Updates."

    Hope that helps!

     

    0
  • Marina Storozhenko
    Comment actions Permalink

    Hi,

    I’m having a problem creating a daily leaderboard for public comments (not solved tickets) made by each agent in my organization. In the rows, I want to see agent names and in the columns, I want to see days of the week for the period of last week or ideally even two weeks. How do I do that? This is as far as I could go but it's in different format and it doesn't even show the dates. Please help.

    0
  • Brandon Tidd
    Comment actions Permalink

    Hi Marina Storozhenko -

    It looks like you might be confusion the row attribute Ticket updated - Day of week with Ticket updated - Date.

    The latter will give you specific dates, whereas your current selection will show you the sum of all of the days in your filtered date range.  Hope this helps!

    Brandon

    1
  • Marina Storozhenko
    Comment actions Permalink

    Hi Brandon Tidd, thank you. But it lists all the dates and as my data populates with every day, this query will become bigger and bigger barely fitting into my dashboard. How do I filter results within a certain time frame?

    Also, the date sequence isn't showing correctly on this report.

    Please help. Thanks.

    0
  • Brandon Tidd
    Comment actions Permalink

    Hey Marina Storozhenko

    You can put up some guardrails via the "Ticket Created - Date" filter.  Hope this helps!

    0

Please sign in to leave a comment.

Powered by Zendesk