Using average or median aggregators

Return to top
Have more questions? Submit a request


  • Breydon Stangeland

    Hi Eugene,

    You mention

    "I will filter out proactive tickets, the once created by agents, from the report because most of them have irregularly high First reply time."

    How do you filter out pro-active tickets (agent created tickets) from your first reply time avg tickets?

    I've been looking for a way to do this for quite some time.

    Is it simply filtering out 'ticket created by [agent]' ?


    [Edit] I just found your great post explaining exactly this question. Sorry about that!

    Looking forward to finding out how.

  • Eugene Orman
    Zendesk Product Manager

    Hi Breydon,  

    The easiest way to filter out the proactive tickets would be by using the Ticket Submitter Role attribute, which unfortunately is not available in Insights. It is available in our new reporting product - Explore, that is in the beta stage at the moment. 

    The best workaround in Insights is to use the Ticket Submitter filter. Since you want to exclude all tickets submitted by agents the filter configuration will be:  Ticket Submitter isn't (names of your agents).

  • Madalina Vural

    is there a way to be able to set up quartiles in reports? For example, if the median is a numeric value that separates the higher half of a set from the lower half. What formula do i use in order to figure out the median value for the lower half and hight half of the data set?

  • Dan Cooper
    Community Moderator

    Hi Madalina, 

    I'm not as familiar with the mathematical principles that you are trying to work through, but if you are familiar with how to generate the equations outside of GoodData, you may be able to use GoodData's Help Center Sections on Metrics and MAQL to help build a query out that accomplishes this for you.

    I will call out that the help center may not be specific to Zendesk, but for an overview of you you might use GoodData as a platform, I'd recommend taking a look to see if something clicks for you. 

  • Caroline Lundström


    The Selecting metric aggregators.  link doesn't work.

    Could you please indicate me where I can find a guide to making one queries and reports in Explore. 

  • Brett Bowser
    Zendesk Community Team

    Hey Caroline,

    Thanks for sharing!

    I'm going to pass this information to our Documentation team to see if we can get that link updated to the correct URL.


  • Rob Stack
    Zendesk Documentation Team

    Hi Caroline, I've now fixed the link. Many thanks for pointing this out to us!

  • Devan - Community Manager
    Zendesk Community Team

    On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!

    Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include: 

    • What it is you're trying to do
    • What you've tried so far 
    • Any other context or relevant information
    • Screenshots, if you have them

    Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!


Please sign in to leave a comment.

Powered by Zendesk