Running/rolling average

Answered

7 Comments

  • Christopher Stock
    Community Moderator

    Hi @..., is it a single figure showing the daily average over the last 7 days that you're looking for?

    0
  • Vladimir Petrushenko

    Hi @... 

    Yeah, that would be great if we could achieve that. Thanks for looking into this 

    0
  • Christopher Stock
    Community Moderator

    No problem. You should be able to achieve what you're after using a filter and 'Result metric calculation'. Using the Support - Tickets dataset:

    1. Add COUNT(Tickets) as your metric.
    2. Add a filter on Ticket created - Date. Select 'Edit date ranges' and add the following 'Advanced' filter
    3. Click on 'Result manipulation' and select 'Result metric calculation'.
    4. Add a new metric, give it a name, then write this formula

    Remember to check 'Clear used metrics'.

    That should give you a figure showing the total number of tickets created over the last 7 days divided by 7.

    0
  • Vladimir Petrushenko

    That does work, thanks for this again @... 

    Do you think I can somehow incorporate that into this report as a separate value/metric? 

    Many thanks 

     

     

    0
  • Christopher Stock
    Community Moderator

    I'm not sure where in that chart the rolling average metric would appear. It might be better to add both to a dashboard and have them displayed side-by-side.

    0
  • Crawford Philleo

    Hello - I'm interested in setting up a metric like this, that would show you the 7-day rolling average of tickets. Looking at the suggestion in this thread, I'm super confused - wouldn't adding a date-range filter for 7-days in the past only ever show you just the most recent 7-day ticket history?

    I want to create a time series that would show me a rolling average of tickets created over a 7-day period, by date.

    So for the X-axis (date), each day represented would show tickets created for each day within a 7-day block in the past from that date, divided by 7 (to get a rolling average). Is this possible? I feel like you'd need something similar to week-buckets as an attribute like described here: https://support.zendesk.com/hc/en-us/articles/4408834272282 -- only for each day of the week if that makes sense. 

    1
  • Diosa
    Hi Crawford Philleo,

    A related topic on rolling average may be found in this other community post, 7-days average. Unfortunately, as indicated in the thread, Explore does not currently have a native method for calculating a rolling average. 

    You may also want to check at Date Range Calculated Metrics, which allows you to create totals for a certain time period; however, this will only be a single figure, and not a continuous trend.
    -1

Please sign in to leave a comment.

Powered by Zendesk