Running/rolling average

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. 

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.

That does work, thanks for this again 2490698108 

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

Many thanks 

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.

Hi Chris Stock 

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

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