Running/rolling average

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

Hi @Chris Stock 

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

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.

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 

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.

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.