Explore recipe: Auditing a random selection of tickets

Return to top


  • Bobby Koch

    This is great - how would we "delay" the random list of tickets? Every time i refresh the page, the tickets re-randomize. Could I bake in a time delay to only refresh once every hour?

  • Maude Joly

    Hi Bobby, 

    It's not possible to "freeze" the results for a certain amount of time while refreshing.
    Performing a refresh means that the function runs again, giving a new set of random data. 

    One thing that I can advise here, is to export your query the first time you run it. By doing this you'll be able to have that results saved and go back to it whenever you want to. 

    Hope that helps! :) 

  • Bobby Koch

    Hiya Maude Joly! thanks for the reply - appreciate you. 

    I think where this turns into an issue is with email deliverability. We have a group of team leads that are supposed to audit these tickets, but we need them to all receive the same tickets, without creating a group. right now, if I set a schedule to send to you and me (not tied to a group) it will generate two completely separate lists of tickets. Just some feedback as it would be nice to be able to randomize on a schedule to avoid inconsistencies. i am sure there is a counter argument as well! 


    Cheers, Bobby

  • Gerald J

    Is there a way that I can extract or limit the number of random tickets? for example I want to only get 10% of the total solved for the week

  • Sarah V

    This is great, thanks for the recipe!

    Would it be also possible to add a column with the initial ticket text (first message from the requester)?


  • Elaine
    Zendesk Customer Care
    Hi Sarah,

    I don't see an option at this since Explore doesn't capture the content of ticket comments you may include the ticket subject attribute. You may also check the lists of attributes that you can use in this article. Hope that helps!
  • Sarah V

    Hi Elaine,

    Thank you for your reply. I'm trying my luck with the json data export from the Admin Center now to get the ticket description text :-) 

  • Lindsey Rhyne

    I gave this a go and the report is working, except that the results don't refresh? I expected to see a new random sample each time I refreshed the report or the page. Anyone know how to fix this?

  • Tony
    Zendesk Customer Care
    Hi there,
    I think it might be related to the fact that reports do not refresh constantly. As this article mentions:
    Data refresh intervals for Explore reporting
    I hope this helps. If you want to check that further, you can reach out to our support.

Please sign in to leave a comment.

Powered by Zendesk