7-days average


4 コメント

  • Le blagueur masqué

    No reply from Zendesk ? Regarding customer support, far from being acceptable..

  • ZZ Graeme Carmichael
    Community Moderator


    Unfortunately, I do not believe this is possible in Explore. 

  • Eric Gao
    Zendesk Customer Care

    Hi Thibault,

    We can confirm on Graeme's comment that there's not a native function in Explore for mapping out a rolling average (e.g. 7 days) as a trendline on queries. We do recommend checking out Date Calculated Metrics, which allows you to create totals for a specified period of time:

    For example, you can create a metric that returns the AVG of tickets created over the past 7 days. Note that this will be a single, discrete value rather than a continuous trend as shown in your screenshot.

    Eric G. Gao | Technical Support Architect | Zendesk

  • Julien Driscoll

    I export Zendesk data to another tool called Acho and write a SQL query to calculate 7-day moving average. Maybe you can try some BI tools to analyze it. I know many BI tools can support SQL queries. 

    (The tool I used in this query is called Acho Studio)



Powered by Zendesk