7-days average

4 댓글

  • Graeme Carmichael
    Community Moderator

    Thibault 

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

    1
  • Eric Gao
    Zendesk Team Member

    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:
    https://support.zendesk.com/hc/en-us/articles/360022184194-Adding-time-and-date-calculated-metrics

    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

    1
  • Thibault Dumont

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

    0
  • 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)

    0

댓글을 남기려면 로그인하세요.

Zendesk 제공