Running/rolling average
AnsweredHi all,
I'm hoping someone could advise whether or not it's possible to see in a query running(or rolling) average of tickets created in the past 7 days for example.
Insights do have this feature and it's handy! We have migrated to Explore and now need to use this feature.
Thanks in advance
-
Hi @..., is it a single figure showing the daily average over the last 7 days that you're looking for?
-
Hi @...
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:
- Add COUNT(Tickets) as your metric.
- Add a filter on Ticket created - Date. Select 'Edit date ranges' and add the following 'Advanced' filter
- Click on 'Result manipulation' and select 'Result metric calculation'.
- 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 @...
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.
-
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.
Please sign in to leave a comment.
7 Comments